how to disable/enable command button (ActiveX) using a macro
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
|