Thread: Protect
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BG BG is offline
external usenet poster
 
Posts: 31
Default 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!