VBA code to unlock password protected worksheets

[Jyoti C]

Hello,

I have created a spreadsheet which is password protects worksheets individually- however each time I want to change something on the spreadsheet it asks me the password to that worksheet- how can I create a macro which un protects all worksheets that have a password? I would like this macro to prompt for a password before it unlocks all worksheets.

Thank you

[PaulSP8]

Hello and Welcome to the Forum

You can do something like this;

Please Login or Register  to view this content.

(Using Sheet1.Protect Passworld:="Pa55w0rd" to protect them again once you're done)

But if your security is paramount then you'd need to protect the VBA as well (Right Click > VBA Project Properties > Protection)

Hope that helps

[davesexcel]

This will unprotect and protect a sheet, but ignore a specific sheet, this example assumes sheet1 is the sheet to ingore.

Please Login or Register  to view this content.