Unprotecting a sheet through a macro
Posted by jamesman on March 23, 2000 8:15 PM
I've got a worksheet that I need to have protected and I need to have a password on it. Now, I'm running a macro in which I need to temporarily unprotect the sheet and then re-protect it later in the function. So if I protect it without a password, all works fine but if I protect it with a password, it won's run. I'm using the "ActiveSheet.Unprotect" at the beginning of my macro and what I don't know is how to tell the macro to use my password in the process.
Any suggestions will be greatly apprecitated.