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.
Bookmarks