protecting the worksheet
 

MySheet.Unprotect Password:="*****"
:
MySheet.Protect Password:="*****"



"Fawn" wrote in message
...
I have a worksheet that I would like to record a macro to protect with a
password and unprotect with a password. When I record the macro it will
not
give me the choice to enter a password before the sheet unprotect.

Don't know if it is possible to do this.

Does anyone have suggestion?

protecting the worksheet
 

I have a worksheet that I would like to record a macro to protect with a
password and unprotect with a password. When I record the macro it will not
give me the choice to enter a password before the sheet unprotect.

Don't know if it is possible to do this.

Does anyone have suggestion?