Protecting Sheets with VBA
 

I have a user who feels they need to password protect some of the cells on a
sheet befor they distribute their sheet. The problem is they are a little
absent minded and forget to go to the Tools=Protection=Protect Sheet menu
item and lock the sheet before they save it.

Is it possible upon closing to lock the sheet with the password they used to
unlock it with?

Protecting Sheets with VBA
 

Not unless they record that password somewhere.

--
Regards,
Tom Ogilvy

"Helen" wrote in message
...
I have a user who feels they need to password protect some of the cells on
a
sheet befor they distribute their sheet. The problem is they are a little
absent minded and forget to go to the Tools=Protection=Protect Sheet
menu
item and lock the sheet before they save it.

Is it possible upon closing to lock the sheet with the password they used
to
unlock it with?