Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have tried to create a macro using recorder to disable/enable command
button (ActiveX) with the following code being created ActiveSheet.Shapes("CommandButton1").Select This only results in the command button being selected - with the procedure of enabling/disabling being "lost". So i tried the following code ActiveSheet.CommandButton1.Select CommandButton1.Enabled = False This presents runtime error message "object required" What is the "simplest" way to create this macro? (first time user) Any help much appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to disable/enable command button(ActiveX) using macro | Excel Discussion (Misc queries) | |||
Enable / Disable Command Button depending on a cell's value | Excel Programming | |||
Enable/Disable Command Button | Excel Programming | |||
Enable / Disable a button using a macro | Excel Programming | |||
Enable/Disable Button | Excel Programming |