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

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

Jim Thomlinson


"sharon" wrote:

> 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

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" wrote:

> First thing check to see if you are in Design Mode.
> --
> HTH...
>
> Jim Thomlinson
>
>
> "sharon" wrote:
>
> > 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

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

Jim Thomlinson


"sharon" wrote:

> 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" wrote:
>
> > First thing check to see if you are in Design Mode.
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
> > "sharon" wrote:
> >
> > > 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

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



"Jim Thomlinson" wrote:

> If you add a new button on that computer does it work?
> --
> HTH...
>
> Jim Thomlinson
>
>
> "sharon" wrote:
>
> > 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" wrote:
> >
> > > First thing check to see if you are in Design Mode.
> > > --
> > > HTH...
> > >
> > > Jim Thomlinson
> > >
> > >
> > > "sharon" wrote:
> > >
> > > > 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

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 wrote:
>
> 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

--

Dave Peterson

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" wrote:

> 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 wrote:
> >
> > 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
>
> --
>
> 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 wrote:
>
> 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" wrote:
>
> > 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 wrote:
> > >
> > > 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
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

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" wrote:

> 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 wrote:
> >
> > 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" wrote:
> >
> > > 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 wrote:
> > > >
> > > > 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
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> 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.

sharon wrote:
>
> 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" wrote:
>
> > 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 wrote:
> > >
> > > 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" wrote:
> > >
> > > > 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 wrote:
> > > > >
> > > > > 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
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson