View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
clara clara is offline
external usenet poster
 
Posts: 252
Default 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