Thread: simple question "disable command buttons"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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.



Reply With QuoteReply With Quote