ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Modifying Locked Cells... :-) (https://www.excelbanter.com/excel-programming/274437-re-modifying-locked-cells.html)

Paul B[_7_]

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





All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com