Hiding buttons/showing them

Hi there

In my sheet, I've got a command button that protects the sheet and unprotects it (code was thanks to this forum) and I'd like to make it so that when the sheet is protected, all the other command buttons are hidden (CommandButton1 to CommandButton5) and then when the sheet is unprotected again, the buttons all show up.

The reason for this is because when other buttons are clicked as the sheet is protected, it brings up the error and shows Debug as an option and then the user can click that to look at the code and password for the protect sheet button.

Thanks for your help.

First, you can keep your code hidden from eyes by protecting the code inside the VBEditor. I use 2003, not 2007 like you have listed, but look in the VBE and you'll find a way to lock your code from prying eyes.

Second, you can try these two pieces of code to insert in your code:

Please Login or Register  to view this content.

Careful here, you stated you wanted to HIDE buttons 1-5, but your code indicates that button1 is the one doing the protecting/unprotecting. In that case, you really only want to hide buttons 2-5? I'll assume so.

Anyway, if the buttons are on the same page, then:

Please Login or Register  to view this content.