Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Sort A-Z not working but did in 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 Formula Not Working Other Users | Excel Discussion (Misc queries) | |||
How do I create a working clock in Excel 2000? | Excel Discussion (Misc queries) | |||
Excel VB 2000 not working in 2003 | New Users to Excel | |||
Crash working with Excel 2000 | Excel Programming |