Detecting a sheet unprotect?

[Don Wiss]

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>.

 

[Jim Thomlinson]

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

 

[gocush]

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.