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