MySheet.Unprotect Password:="*****" : MySheet.Protect Password:="*****"
F Fawn Dec 4, 2005 #2 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?
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?
