Forum Discussion

Copper Contributor

May 30, 2023

Excel script to disable password / unprotect, then re-apply at end of script

I am using excel scripts. My challenge is to remove protection from a password protected worksheet, apply changes, then re-apply password protection. I'd be grateful for help with the portions of t...

excel

Office Scripts

Bkkendig

Copper Contributor

May 31, 2023

Thanks. However, I am also looking for the code that hardcodes the password to disable password protection, then turns it back on at the end.

mtarler

Silver Contributor

May 31, 2023

Yes look at lines 6,7,17

I edited above comment to indicate that it unlocks the sheet, THEN toggles, then Relocks the sheet