What kind of buttons do you have... Forms Toolbar or Control Toolbox?
--
HTH...

Jim Thomlinson


"eighthman11" wrote:

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.