code to unprotect sheet with password
I need to run a macro that first unprotects a password protected sheet, and
then reprotects it later, with a password. The user will not know the
password, and therefore the code needs to, itself, have it hardcoded in
there. I am not concerned about someone digging in the code and finding the
password, so assume that's not an issue.
Is this possible, and if so, what is the code?
Thanks.
--
Boris
|