| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable autoformat of "true" and "false" text | Excel Discussion (Misc queries) | |||
| Simple Question............Deleting "Name Box" name! | Excel Discussion (Misc queries) | |||
| 2007 Need macro to auto set option buttons all to "Yes" or "No" | Excel Worksheet Functions | |||
| how can I disable "cutting cells" and "drag and drop "in excel ? | Excel Worksheet Functions | |||
| Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
Linear Mode
