simple question "disable command buttons"
 

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.

simple question "disable command buttons"
 

Use this if you are sure that the controltool box button is on the active sheet when you open the workbook

ActiveSheet.OLEObjects("CommandButton1").Enabled = False



--
Regards Ron de Bruin
http://www.rondebruin.nl



"eighthman11" wrote in message ups.com...
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.