changing button prop with vba

[Guest]

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?

 

[Guest]

You can not use Activesheet. You need to specifically reference the sheet
that the button is on. Something like this...

Sheet1.btnReconciliation.enable = True

 

[Nigel]

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

 

[Nigel]

Actually that is not true, you can use the activesheet but it is not good
practice, so always reference it explicitly, See my other post for the fix
which is actually a typo which should use Enabled property not enable

 

[Sandy]

Here are a couple of different ways to enable/disable a commandbutton:

From another worksheet:

Worksheets("Sheet2").CommandButton1.Enabled = True

On the current worksheet
CommandButton1.Enabled = False
-or-
ActiveSheet.CommandButton1.Enabled = False


Hope this helps...

Sandy

 

[Sandy]

Here are a couple of different ways to enable/disable a commandbutton:

From another worksheet:

Worksheets("Sheet2").CommandButton1.Enabled = True

On the current worksheet
CommandButton1.Enabled = False
-or-
ActiveSheet.CommandButton1.Enabled = False


Hope this helps...

Sandy

 

[Sandy]

Here are a couple of different ways to enable/disable a commandbutton:

From another worksheet:

Worksheets("Sheet2").CommandButton1.Enabled = True

On the current worksheet
CommandButton1.Enabled = False
-or-
ActiveSheet.CommandButton1.Enabled = False


Hope this helps...

Sandy

 

[Sandy]

WOW!! not sure what happened sorry for the multiple posts...

 

[Guest]

Thank you that worked

ProgramControl.btnReconciliation.Enabled = True

 

[Guest]

Nice catch. I missed the typo. I figured that the button was not on the
activesheet which caused the problem... you are absolutely correct.