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

Jim Thomlinson


"Nigel" wrote:

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

--
Cheers
Nigel



"Jim Thomlinson" wrote in message
...
You can not use Activesheet. You need to specifically reference the sheet
that the button is on. Something like this...

Sheet1.btnReconciliation.enable = True

--
HTH...

Jim Thomlinson


"Arnold Klapheck" wrote:

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?