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