The .Protect and .Unprotect methods have an optional parameter which is the password. Are you sure you're supplying it when you unprotect and when you re-protect ?
I have an excel spreadsheet with 2 simple macros, which run in a specific order. Both macros unprotect the spreadsheet as the first step, and protect with the last step (password is included in code). After I run the first macro, if I go to unprotect the sheet, I am NOT prompted for a password. If I run the second macro, and then try to unprotect the sheet, I am prompted for a password. The macros both have the same language...???
The .Protect and .Unprotect methods have an optional parameter which is the password. Are you sure you're supplying it when you unprotect and when you re-protect ?
Yes - both macros are identical with regards to the protect, unprotect. I am begining to think it is a glitch.
Like this thread? Share it with others