Protect
 

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!

Protect
 

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.

bg wrote:

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!

--

Dave Peterson