Allow disabling of password, but no setting of password
I have a sheet that is password protected and the p/word is only known
by selected group of user(s). I reset the password protection in the
"Deactivate" event so that the user does not have to remember to enable
protection each time.
The problem is that the user might decide to enter another p/word and
this could cause further code to crash. Is there a way that I can
disallow the user from setting another p/word?
|