B
bg
Hi, I am trying to protect data driven by VBA in Columns A:I and L2
20 but
want the user to be able to make calculations on the tab as well. I was using
this:
ws.Protect "Sheet1", UserInterfaceonly:=True
but I'm not sure how to edit it to protect a range of data?
Can anyone help? Thanks in advance!

want the user to be able to make calculations on the tab as well. I was using
this:
ws.Protect "Sheet1", UserInterfaceonly:=True
but I'm not sure how to edit it to protect a range of data?
Can anyone help? Thanks in advance!