Excel 2000 code not working in XP
 

I have some code that deals with buttons developed in
Excel 2000 that doesn't work on a client's PC with Office
XP. The thing is, we tested it on one of our own XP
machines and it worked fine.

The button is the old style forms objects, since some of
our other users are still on excel 95 and 97. I think the
code bugs out when the macro tries to refer to the name of
the button.

Can anybody please tell me what might be causing this? My
first thought is that the client is missing a library or
something from their install of Office.

Thanks.
Shane

Excel 2000 code not working in XP
 

Shane,

Yes, it could be a missing library.
From VBA (ALT+F11) go to the menu Tools | References. Check for MISSING:


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Shane J" wrote in message
...
I have some code that deals with buttons developed in
Excel 2000 that doesn't work on a client's PC with Office
XP. The thing is, we tested it on one of our own XP
machines and it worked fine.

The button is the old style forms objects, since some of
our other users are still on excel 95 and 97. I think the
code bugs out when the macro tries to refer to the name of
the button.

Can anybody please tell me what might be causing this? My
first thought is that the client is missing a library or
something from their install of Office.

Thanks.
Shane

Excel 2000 code not working in XP
 

You may want to post the code and indicate what line is failing if Rob's
suggestion doesn't help.


Shane J wrote:

I have some code that deals with buttons developed in
Excel 2000 that doesn't work on a client's PC with Office
XP. The thing is, we tested it on one of our own XP
machines and it worked fine.

The button is the old style forms objects, since some of
our other users are still on excel 95 and 97. I think the
code bugs out when the macro tries to refer to the name of
the button.

Can anybody please tell me what might be causing this? My
first thought is that the client is missing a library or
something from their install of Office.

Thanks.
Shane

--

Dave Peterson