I have a macro that turns worksheet protection off before
it runs, then turns it back on after it's done.

Can I embed a password in the macro instructions that
activate and deactivate protection so that a user cannot
just go through the menu to turn off the protection?

activesheet.protect Password:="ABCD"

activesheet.unprotect Password:="ABCD"

look in excel vba help for other arguments to protect and unprotect.

Also, try recording a macro while you do it manually (assigning a password
as well).

--
Regards,
Tom Ogilvy

"Bob" wrote in message
...
I have a macro that turns worksheet protection off before
it runs, then turns it back on after it's done.

Can I embed a password in the macro instructions that
activate and deactivate protection so that a user cannot
just go through the menu to turn off the protection?