Excel 2000 code not working in XP

  • Thread starter Thread starter Shane J
  • Start date Start date
S

Shane J

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
 
Shane,

Yes, it could be a missing library.
From VBA (ALT+F11) go to the menu Tools | References. Check for MISSING:
 
You may want to post the code and indicate what line is failing if Rob's
suggestion doesn't help.
 
Back
Top