Enable/disable CommandButton

[DerbyDesign]

I created CommandButton1 using Control Toolbox and I set its property to Enabled = True. Is there a (simple) way to swap between Enable/Disable from macro?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
The line
<o> </o>
ActiveSheet.Shapes("CommandButton1").Enabled = False
<o> </o>
generates an error (Object doesn't support this property or method) contrary to
<o> </o>
ActiveSheet.Shapes("CommandButton1").Visible= False
<o> </o>
that works perfectly.

Which CommandButton properties can and which cannot be (simply) altered from within macro? I was unable to find anything in Excel VBA help.
<o> </o>
Thanks,
<o> </o>
-dd

 

[phxsportz]

it's just

commandbutton1.enabled = False

 

[phxsportz]

Switches back and forth between enabled and not

Private Sub worksheet_activate()
    If CommandButton1.Enabled Then
        CommandButton1.Enabled = False
    Else
        CommandButton1.Enabled = True
    End If
End Sub

 

[DerbyDesign]

Bingo! Well, actually ActiveSheet.CommandButton1.Enabled= False (True) works like a charm. Thanks a lot.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
-dd<o></o>