Button to toggle worksheet protection on/off?

I have created two macros, one to lock a worksheet, and another to unlock it. I inserted two form control buttons at the bottom of the worksheet, and assigned the macros to the buttons. So now I can toggle between a locked and unlocked worksheet. But I can't tell if the sheet is locked or not.

Now I would like to be able to see if the worksheet is locked or not. Ideally, I'd like one button that toggles the worksheet protection on and off, and the word in the button changes between "Locked" and "Unlocked". Or, I can still use two buttons, perhaps with the "Locked" word or "Unlocked" word changing color so that I can tell the locked status.

Any help appreciated!

Hi,

I have uploaded an attachment which covers both options that you have covered above.

In Sheet1, if the sheet is protected, the "Protect Worksheet" button is disabled and vice-versa.
In Sheet2, the protect/unprotect function is handled with a single button.

Note that there is code in each of the click events for the buttons, and also in the workbook open event.

Hope this helps

Hi,

If you change all references to

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

then the button will work on whichever worksheet it is placed on, so you can copy the button and the code.