View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default 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