simple question "disable command buttons"

E

eighthman11

Quick simple question. I want to disable a command button when my
excel spreadsheet is opened. I've tried the following code. It does
not work.

Private Sub Workbook_Open()

ActiveSheet.Buttons("CommandButton1").Enabled = False
ActiveSheet.Buttons("CommandButton2").Enabled = False


End Sub

any help appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide a command button 9
Re: how to disable/enable command button (ActiveX) using a macro 3
Command button caption from cell value 4
Command Button Help 2
How can i Enable/Disable CommandButtons from Wkbook Open event ??? 1
How to enumerate buttons on user form 2
Disable Cut/Copy/Paste in Excel 2010 0
Userform problem (Listindex) 3

Top