View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KobusD KobusD is offline
external usenet poster
 
Posts: 11
Default 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?