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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable autoformat of "true" and "false" text | 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 | |||
simple question "disable command buttons" | Excel Programming | |||
Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) |