Command buttons DEAD

[sharon]

I have a PC (XP Prof) where Excel 2003 command buttons DO NOTHING. They look
like if they were dead.

If I execute macros from ViusalBasic within Excel it is fine.

So far I checked Application.EnableEvents and its value is True
I have security level in Low

In all other computers the workbooks execute commnand buttons Ok.

What should I change or check?

TIA,
Sharon

 

[Jim Thomlinson]

First thing check to see if you are in Design Mode.

 

[sharon]

Hi Jim,

No Design Mode. Just open the workbook and the buttons are inactive. As
said, If I excute the module manually, everything is fine (but tthe buttons!)

Sharon

 

[Jim Thomlinson]

If you add a new button on that computer does it work?

 

[sharon]

Actually it doesn't allow to add any control, but it used to be possible.

Now I have erased/reinstalled EXCEL 2 times something is missing... and I
realize I can't install Microsoft ActiveX DataObjects 2.6 Library

Usually it comes more smooth on a new installation...

Any clue?
TIA,
Sharon

 

[Dave Peterson]

Do you have multiple windows open to that worksheet?
(do you see something like Book1.xls:1 or book1.xls:2 in the title bar?)

If you do close the windows (or try clicking on a button displayed in the other
window).

 

[sharon]

Hi Dave,

I just have one workbook opened, just one window focussing it.

If I try to Add complements (VBA, Solver, etc..) it appears error windows
several times, untill I unclick this option...
I guess it has to do with Windows Registry and new installation, since I had
to format the PC and install all software again (having done all updates
before from Windows Update).
Never before installing Micrsoft Office (I did it some in many PC's) I found
a trouble like this.
So, must I look for something special in Windows Registry.. any key to be
changed?

TIA,
Sharon

 

[Dave Peterson]

And if you go into design mode and double click on one of the commandbuttons,
what happens?

You should be taken to its _Click event.

If you're not, then maybe you added a button from the Forms toolbar--not a
commandbutton from the Control toolbox toolbar.

If you rightclick on the button, do you see an option to Assign macro?

If yes, then the next question is are you sure you wanted the commandbutton or
did you really want the Forms button?

 

[sharon]

Hi Dave,

Yes, it adressess you to the code.

But I can't add a single new button in the worksheets.
BTW, I've reinstalled Windows and Office 2003. All fine but Excel crashes
and the message has to do with "Not Enough Memory") and it also says "It
can't find specified module" (with no name).

MANUALLY, IT RUNS, BUT it crashes with same pop-up window...Memory ...

?????

Could it be more RAM is needed, although it's been working for last 4
years....??

Sharon

 

[Dave Peterson]

I don't really have a guess, but it can't hurt to close excel and clean up your
windows temp folder.

Close excel
windows start button|Run
type:
%temp%
and hit enter

Delete everything you can see.

You may have to do it multiple times and you may have to select them nicely--if
any are in use, you'll want to skip them when you do the subsequent deletes.

Hi Dave,

Yes, it adressess you to the code.

But I can't add a single new button in the worksheets.
BTW, I've reinstalled Windows and Office 2003. All fine but Excel crashes
and the message has to do with "Not Enough Memory") and it also says "It
can't find specified module" (with no name).

MANUALLY, IT RUNS, BUT it crashes with same pop-up window...Memory ...

?????

Could it be more RAM is needed, although it's been working for last 4
years....??

Sharon

 

[sharon]

HI Dave,

I could easily clean all the elements, with no problem.
I can load the workbook but command buttons are still dead.

I see there are troubles with Complements (If I try to install any, it
crashes)
If I do not install any Complement I can run MANUALLY the code and it works
fine.

There's something that goes far beyond me...

Sharon

 

[Dave Peterson]

I'm out of guesses.

Good luck.

HI Dave,

I could easily clean all the elements, with no problem.
I can load the workbook but command buttons are still dead.

I see there are troubles with Complements (If I try to install any, it
crashes)
If I do not install any Complement I can run MANUALLY the code and it works
fine.

There's something that goes far beyond me...

Sharon

 

[sharon]

Hi Dave,

Thanks anyway.

Sharon

I'm out of guesses.

Good luck.