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?

Not unless they record that password somewhere.

--
Regards,
Tom Ogilvy

"Helen" <[email protected]> wrote in message
news:[email protected]...
> 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?