changing button prop with vba
Try using Enabled not Enable, also to avoid running the code against the
wrong active sheet specify the sheet explicitly
ActiveSheet.btnReconciliation.Enabled = True
or explicitly
Sheets("Sheet1").btnReconciliation.Enabled = True
--
Cheers
Nigel
"Arnold Klapheck" wrote in
message ...
I have set a buttons enable property to false for startup and am now trying
to enable the button. It is directly on the worksheet and named
btnReconciliation I have tried the following.
Sub EnableReconcil()
ActiveSheet.btnReconciliation.enable = True
'Runtime error 438 Object dosn't support this property or message
ActiveSheet.Buttons("btnReconciliation").enable = True
'Runtime error 1004 unable to get buttons property of the worksheet class
ActiveSheet.OLEObjects("btnReconciliation").enable = True
'Runtime error 1004 unable to get buttons property of the worksheet class
End Sub
any ideas what I could do?
|