Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting a sheet unprotect?
It doesn't seem possible to detect when a user unprotects a sheet. It
doesn't set off a Worksheet_Change event. Is there some way to detect this? Don <donwiss at panix.com. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting a sheet unprotect?
Password protect the sheet. If the user legitimately need to unprotect the
sheet give thtem a button to do so and you will know when they are unprotecting. You will want to give them another button to protect. The only hole in this plan is if the unprotect using your button and then re portect using the menu... Otherwise I am not aware of any way to catch that event... HTH "Don Wiss" wrote: It doesn't seem possible to detect when a user unprotects a sheet. It doesn't set off a Worksheet_Change event. Is there some way to detect this? Don <donwiss at panix.com. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting a sheet unprotect?
Don,
I haven't tried this but perhaps a Worksheet_change event in which you look for an err. ie when the user tries to change a locked cell and gets the "protected sheet error msg" that should give your sub an error, which you want and will then be ignored by your code. On the other hand if there is NO error then you can take whaterver steps you want, knowing that the sheet is not protected. "Don Wiss" wrote: It doesn't seem possible to detect when a user unprotects a sheet. It doesn't set off a Worksheet_Change event. Is there some way to detect this? Don <donwiss at panix.com. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to Unprotect sheet | Excel Discussion (Misc queries) | |||
Unprotect sheet when printing | Excel Discussion (Misc queries) | |||
Detecting Macro Code behind a sheet (2) | Excel Programming | |||
Detecting Macro code behind a sheet | Excel Programming | |||
unprotect sheet in code and make sheet visible | Excel Programming |