Making an ActiveX control button inactive?

[infinity]

Hi all,

This is probably a really simple thing to do and I know it is possible because I see it all the time with the "APPLY" button in Windows. I need to be able to select an ActiveX button and make it inactive in the process of running a macro. Thanx in advance for your help.

Scott

[Jacob Hilderbrand]

Try this.

CommandButton1.Enabled = False

[infinity]

Thank you Jake, I tried this;

ActiveSheet.Shapes("Button 11").Select
    CommandButton1.Enabled = False

That returns an error that reads " Run time error '424' object required"
What does that mean and how do I make it work properly?

Thanx for your help

Scott

[Jacob Hilderbrand]

The error means that the object that you referenced (in this case CommandButton1) does not exists.

You need to use the ActiveX Command Button control instead of the Forms Button.

You can get the Command Button control from the Control Toolbox on the Visual Basic toolbar.

When you use this line:

CommandButton1.Enabled = False

CommandButton1 must be the name of the control. Change as needed.

[Bob Phillips]

ActiveSheet.Shapes("Button 11").Select
    CommandButton1.Enabled = False

That returns an error that reads " Run time error '424' object required"
What does that mean and how do I make it work properly?

With ActiveSheet.Buttons("Button 11")
        .Enabled = False
    End With

[infinity]

Did I mention you all are awesome?

With ActiveSheet.Buttons("Button 11")
.Enabled = False
End With

Thank you this worked exactly the way I wanted it to. Thanx again

Scott