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?

changing button prop with vba
 

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?

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?

changing button prop with vba
 

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?

changing button prop with vba
 

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

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?

changing button prop with vba
 

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

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?

changing button prop with vba
 

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

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?

changing button prop with vba
 

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


Sandy wrote:
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

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?

changing button prop with vba
 

Thank you that worked

ProgramControl.btnReconciliation.Enabled = True

"Jim Thomlinson" wrote:

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

changing button prop with vba
 

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?