Protect

B

bg

Hi, I am trying to protect data driven by VBA in Columns A:I and L2:p20 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!
 
D

Dave Peterson

With stuff like this, I find it easiest to record a macro when I do it
manually. Then I have the syntax and I can tweak it for what I need.

You may want to try that.
 
Top