View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
will07 will07 is offline
external usenet poster
 
Posts: 28
Default Sheet Protection & Password

Hello Everybody,

Is it possible to add some code to each worksheet that will enable me to
protect the worksheet and have a permanent password. At the moment, when you
unprotect the worksheet, you have to re-enter the password (twice) to protect
it again. I would like to be able to have the password in place all the time
so the user does not have to re-enter it again and again.

Thanks heaps