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
|