View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul B[_7_] Paul B[_7_] is offline
external usenet poster
 
Posts: 73
Default Modifying Locked Cells... :-)

you could also protect it using UserInterfaceOnly, like this

Sheet1.Protect UserInterfaceOnly:=True ', password:="123"
'your code here

"blc" wrote in message
...
Hello all,

Quick question: Is there any way to lock or protect cells
so users cannot edit/modify their contents *YET* still be
able to "programatically" edit/modify the contents of
those same locked or protected cells???

Any help would be appreciated...

Thank you in advance,

blc