Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
Modifying multiple cells crash | Excel Discussion (Misc queries) | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
Modifying UnProtected Cells | Excel Discussion (Misc queries) | |||
Modifying Locked Cells... :-) | Excel Programming |