Protect/Un-protect multiple sheets with password using VBA

Essentially:

Please Login or Register  to view this content.

but you will probably need to tweak/add error handling to suit your needs.

Hi yudlugar,

Appreciate your help.

I have a master password to protect all the sheets e.g test. My requirement is when I run the macro to Protect, the macro should protect the spreadsheets using master password and without a password prompt. And when i run macro to unprotect, it should prompt for correct password i.e test. In your code, any user can protect and un-protect the sheets with their own password.

Sorry I may not have been clear in my initial post.

Please Login or Register  to view this content.

Many thanks for your help.

Last one, I need a msgbox to alert if an incorrect password is entered when macro Un-protect is run.

Regards,

Please Login or Register  to view this content.