Hiding/Revealing Command Buttons

[richh]

Howdy folks!

I'm running Excel 2010

I have a worksheet ("Interface") on which are several controls. One unlocks the workbook and reveals several hidden sheets ("wbUnlock"). One locks the workbook and hides the sheets ("wbLock"). The other buttons allow users to view and retrieve data without being able to manipulate the source ("empLookup"; ""genReports"). I would like to a way to hide the buttons when wbLock is clicked and reveal them once wbUnlock is clicked.

I've tried numerous ways to get this to work, but I keep getting errors. The one I thought would work is...

Sheets("Interface").empLookup.Visible = True/False (depending on button clicked ) | Error "Object doesn't support this property or method"

Is there another way I can hide/reveal these buttons?

 

[JoeMo]

Depends on whether you are using forms control buttons or active-x control buttons. See below for each type.

Sub test()
ActiveSheet.Shapes("Button 1").Visible = False  'this will hide a forms control button named "Button 1"
ActiveSheet.CommandButton1.Visible = False      'this will hide an active-x control button named "CommandButton1"
End Sub

 

[richh]

Thank you JoeMo! I was using the Syntax of an Active-X Control for a forms control button. Thanks for your help!

 

[JoeMo]

Thank you JoeMo! I was using the Syntax of an Active-X Control for a forms control button. Thanks for your help!

You are welcome - thanks for the reply.