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