View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
enahs_naneek enahs_naneek is offline
external usenet poster
 
Posts: 4
Default 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