Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |||
enable/disable button based on cell value | Excel Discussion (Misc queries) | |||
Enable Command Button Procedure | Excel Discussion (Misc queries) | |||
Getting an ActiveX command button to do a spreadsheet function | Excel Worksheet Functions | |||
Enable Command Button base on UserName | Links and Linking in Excel | |||
Enable Command Button After Entering Text | New Users to Excel |