a strange button state
 

the button become disable

is it truly disabled? absolutely does nothing when you click it?
or is it just not in focus?

if it's truly disabled, there must be something in an auto-open sub
that's changing the status. or a before-close sub that resets it
before you even get out of the workbook.

hth
susan


On May 23, 8:12 am, clara wrote:
Hi all,

I have a button(ActiveX control) on a worksheet, before I save the workbook,
I set the button's Enabled to true and I save and close the workbook. Next
time, when I open the workbook, the button become disable but the property
Enabled is still true. Why.

Clara
--
thank you so much for your help

a strange button state
 

Hi Susan,

First I save the workbook and after that the button is ok then I close the
workbook and when I open it again, the button appears disabled it does
nothing when I click it the strange thing is its Enabled property is still
true. I use a Stop statement in the open event of the workbook, and add the
button's Enabled change in the Watch. If the code in Open event change the
property, the execution will enter the debug mode, but nothing happen. This
programm is other person's work, I am just adding new features, so I can not
understand what happens here.


Clara
thank you so much for your help


"Susan" wrote:

the button become disable

is it truly disabled? absolutely does nothing when you click it?
or is it just not in focus?

if it's truly disabled, there must be something in an auto-open sub
that's changing the status. or a before-close sub that resets it
before you even get out of the workbook.

hth
susan


On May 23, 8:12 am, clara wrote:
Hi all,

I have a button(ActiveX control) on a worksheet, before I save the workbook,
I set the button's Enabled to true and I save and close the workbook. Next
time, when I open the workbook, the button become disable but the property
Enabled is still true. Why.

Clara
--
thank you so much for your help

a strange button state
 

If it is from the control toolbox toolbar, perhaps you are in design mode.
You can switch this off by using the upper left control in the control
toolbox toolbar.

--
Regards,
Tom Ogilvy


"clara" wrote:

Hi Susan,

First I save the workbook and after that the button is ok then I close the
workbook and when I open it again, the button appears disabled it does
nothing when I click it the strange thing is its Enabled property is still
true. I use a Stop statement in the open event of the workbook, and add the
button's Enabled change in the Watch. If the code in Open event change the
property, the execution will enter the debug mode, but nothing happen. This
programm is other person's work, I am just adding new features, so I can not
understand what happens here.


Clara
thank you so much for your help


"Susan" wrote:

the button become disable

is it truly disabled? absolutely does nothing when you click it?
or is it just not in focus?

if it's truly disabled, there must be something in an auto-open sub
that's changing the status. or a before-close sub that resets it
before you even get out of the workbook.

hth
susan


On May 23, 8:12 am, clara wrote:
Hi all,

I have a button(ActiveX control) on a worksheet, before I save the workbook,
I set the button's Enabled to true and I save and close the workbook. Next
time, when I open the workbook, the button become disable but the property
Enabled is still true. Why.

Clara
--
thank you so much for your help

a strange button state
 

Another possibility is that you haven't put commands in the click event. Has
it worked in the past?

--
Regards,
Tom Ogilvy


"clara" wrote:

Hi Susan,

First I save the workbook and after that the button is ok then I close the
workbook and when I open it again, the button appears disabled it does
nothing when I click it the strange thing is its Enabled property is still
true. I use a Stop statement in the open event of the workbook, and add the
button's Enabled change in the Watch. If the code in Open event change the
property, the execution will enter the debug mode, but nothing happen. This
programm is other person's work, I am just adding new features, so I can not
understand what happens here.


Clara
thank you so much for your help


"Susan" wrote:

the button become disable

is it truly disabled? absolutely does nothing when you click it?
or is it just not in focus?

if it's truly disabled, there must be something in an auto-open sub
that's changing the status. or a before-close sub that resets it
before you even get out of the workbook.

hth
susan


On May 23, 8:12 am, clara wrote:
Hi all,

I have a button(ActiveX control) on a worksheet, before I save the workbook,
I set the button's Enabled to true and I save and close the workbook. Next
time, when I open the workbook, the button become disable but the property
Enabled is still true. Why.

Clara
--
thank you so much for your help

a strange button state
 

Hi Tom,

It worked before and I think your first guess is correct because the same
problem happens to other buttons, but after some setting and switching to and
from design mode, it works.Could you elaborate a little about your solution
again?

Thank you very much

Clara
--
thank you so much for your help


"Tom Ogilvy" wrote:

Another possibility is that you haven't put commands in the click event. Has
it worked in the past?

--
Regards,
Tom Ogilvy


"clara" wrote:

Hi Susan,

First I save the workbook and after that the button is ok then I close the
workbook and when I open it again, the button appears disabled it does
nothing when I click it the strange thing is its Enabled property is still
true. I use a Stop statement in the open event of the workbook, and add the
button's Enabled change in the Watch. If the code in Open event change the
property, the execution will enter the debug mode, but nothing happen. This
programm is other person's work, I am just adding new features, so I can not
understand what happens here.


Clara
thank you so much for your help


"Susan" wrote:

the button become disable

is it truly disabled? absolutely does nothing when you click it?
or is it just not in focus?

if it's truly disabled, there must be something in an auto-open sub
that's changing the status. or a before-close sub that resets it
before you even get out of the workbook.

hth
susan


On May 23, 8:12 am, clara wrote:
Hi all,

I have a button(ActiveX control) on a worksheet, before I save the workbook,
I set the button's Enabled to true and I save and close the workbook. Next
time, when I open the workbook, the button become disable but the property
Enabled is still true. Why.

Clara
--
thank you so much for your help

a strange button state
 

Hi Tom,

It is in Design mode I am sure.

Clara
--
thank you so much for your help


"Tom Ogilvy" wrote:

If it is from the control toolbox toolbar, perhaps you are in design mode.
You can switch this off by using the upper left control in the control
toolbox toolbar.

--
Regards,
Tom Ogilvy


"clara" wrote:

Hi Susan,

First I save the workbook and after that the button is ok then I close the
workbook and when I open it again, the button appears disabled it does
nothing when I click it the strange thing is its Enabled property is still
true. I use a Stop statement in the open event of the workbook, and add the
button's Enabled change in the Watch. If the code in Open event change the
property, the execution will enter the debug mode, but nothing happen. This
programm is other person's work, I am just adding new features, so I can not
understand what happens here.


Clara
thank you so much for your help


"Susan" wrote:

the button become disable

is it truly disabled? absolutely does nothing when you click it?
or is it just not in focus?

if it's truly disabled, there must be something in an auto-open sub
that's changing the status. or a before-close sub that resets it
before you even get out of the workbook.

hth
susan


On May 23, 8:12 am, clara wrote:
Hi all,

I have a button(ActiveX control) on a worksheet, before I save the workbook,
I set the button's Enabled to true and I save and close the workbook. Next
time, when I open the workbook, the button become disable but the property
Enabled is still true. Why.

Clara
--
thank you so much for your help

a strange button state
 

for controls from the control toolbox toolbar, you can put the sheet in
design mode so you can address their properties and work with their event
code. You take the sheet out of design mode to actually have the control
function (execute the code when clicked).

The design mode control is in the control toolbox toolbar in the upper left
corner (usually) - it has a drawing triangle on it. when in design mode, it
appears depressed. When not in design mode, it looks normal. (this is when
the control toolbox toolbar is visible). Sometimes when in design mode, a
floating toolbar will appear with this control

--
Regards,
Tom Ogilvy


"clara" wrote:

Hi Tom,

It worked before and I think your first guess is correct because the same
problem happens to other buttons, but after some setting and switching to and
from design mode, it works.Could you elaborate a little about your solution
again?

Thank you very much

Clara
--
thank you so much for your help


"Tom Ogilvy" wrote:

Another possibility is that you haven't put commands in the click event. Has
it worked in the past?

--
Regards,
Tom Ogilvy


"clara" wrote:

Hi Susan,

First I save the workbook and after that the button is ok then I close the
workbook and when I open it again, the button appears disabled it does
nothing when I click it the strange thing is its Enabled property is still
true. I use a Stop statement in the open event of the workbook, and add the
button's Enabled change in the Watch. If the code in Open event change the
property, the execution will enter the debug mode, but nothing happen. This
programm is other person's work, I am just adding new features, so I can not
understand what happens here.


Clara
thank you so much for your help


"Susan" wrote:

the button become disable

is it truly disabled? absolutely does nothing when you click it?
or is it just not in focus?

if it's truly disabled, there must be something in an auto-open sub
that's changing the status. or a before-close sub that resets it
before you even get out of the workbook.

hth
susan


On May 23, 8:12 am, clara wrote:
Hi all,

I have a button(ActiveX control) on a worksheet, before I save the workbook,
I set the button's Enabled to true and I save and close the workbook. Next
time, when I open the workbook, the button become disable but the property
Enabled is still true. Why.

Clara
--
thank you so much for your help

a strange button state
 

Well, that the problem. You need to be NOT in Design Mode for this control
to function.

NickHK

"clara" wrote in message
...
Hi Tom,

It is in Design mode I am sure.

Clara
--
thank you so much for your help


"Tom Ogilvy" wrote:

If it is from the control toolbox toolbar, perhaps you are in design
mode.
You can switch this off by using the upper left control in the control
toolbox toolbar.

--
Regards,
Tom Ogilvy


"clara" wrote:

Hi Susan,

First I save the workbook and after that the button is ok then I close
the
workbook and when I open it again, the button appears disabled it does
nothing when I click it the strange thing is its Enabled property is
still
true. I use a Stop statement in the open event of the workbook, and
add the
button's Enabled change in the Watch. If the code in Open event change
the
property, the execution will enter the debug mode, but nothing happen.
This
programm is other person's work, I am just adding new features, so I
can not
understand what happens here.


Clara
thank you so much for your help


"Susan" wrote:

the button become disable

is it truly disabled? absolutely does nothing when you click it?
or is it just not in focus?

if it's truly disabled, there must be something in an auto-open sub
that's changing the status. or a before-close sub that resets it
before you even get out of the workbook.

hth
susan


On May 23, 8:12 am, clara wrote:
Hi all,

I have a button(ActiveX control) on a worksheet, before I save the
workbook,
I set the button's Enabled to true and I save and close the
workbook. Next
time, when I open the workbook, the button become disable but the
property
Enabled is still true. Why.

Clara
--
thank you so much for your help