Macro Protect & Unprotect Multiple Worksheets & Workbook (Structure) With same Password

[marsham]

Hi,

I am new to Macros and have only recently started recording little ones.
I don't understand the language of them very well and as such trawled Google and found this one on a site from many years ago.
It promises to do what I need - i.e. Protect & unprotect Multiple Worksheets AND Workbook Structure with a lot less clicks than I would need if doing it manully.
I have tested it, but it doesn't seem to work just so - It protects everything but it allows me to unprotect the workbook without the use of a password. I did change the Password - but have taken it back to how I found it for the forum.

Could someone help me - I just want to Protect ALL Worksheets - Protect All Workbook (Structure) - Unprotect All Workbook (Structure) - Unprotect ALL Worksheets. 4 Steps - Passwords required to UnProtect (Both Stages) Oh and use the same password.

Thanks in Advance.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.