| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing button prop with vba
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| R/T 1004 - Unable to get Button prop of Ws Class | Excel Discussion (Misc queries) | |||
| Changing text on a button | Excel Discussion (Misc queries) | |||
| prop. scale images - have code, just need slight mod | Excel Programming | |||
| TEMPLATE IN EXCEL FOR MONTHLY PAYMENTS FOR MORE THAN ONE PROP | New Users to Excel | |||
| CommandBarButton.OnAction prop fires when set? Arg! | Excel Programming | |||
Threaded Mode
