FIXED - MAcro to protect/unprotect sheets based on password in cell

Hi,

I have a lovely macro which protects all of my sheets (even asks me nicely if i want to protect each individual sheet) and a unprotect one too.

However these are useless as others can press these buttons and edit my spreadsheets. They need to view the spreadsheet but i need to protect from sticky fingers...

I would protect the sheets manually or leave the unprotect macro out of it but i have a LOT of sheets i need to work with... takes ages doing it the manual way.

So what i would like to do is protect or unprotect ALL sheets based on what text appears in a certain cell, for example:

Cell A1 has "password" in it, i press lock all sheets button and all sheets are now locked
Cell A1 has nothing in it, i press lock all sheets button and a warning message appears saying wrong password

And vice versa for the unprotect part..

Can anyone help?

It will be good if you attach your macro file here. I feel it requires some minor changes.

How do you plan to state the cell? Do you want a msgbox asking for the cell address?

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Maybe something like this

Please Login or Register  to view this content.

You only need to cahnge if to UnProtect, or you could have a procedure that you call & define what you want to do

Please Login or Register  to view this content.