spreadsheet macros run fine at home, but not on other computer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gerri Reno - 03 Nov 2007 20:52 GMT

I build large spreadsheets for my clients. Recently a sheet that I built gave
me a new problem. The sheet contains over 100 macros. I tested all of them,
and they ran fine on my computer. When I copy the sheet to my client's
computer, I keep getting sent to debugging when I try to run any of the
macros. The highlighted parts of the macro all seem to be correct. Is there a
Windows version problem? I use XP 2000 Pro, while my client is in 2000
Professional. I have tried saving the sheet in earlier versions of Office,
but that had no effect.

Reply to this Message

Gary''s Student - 03 Nov 2007 22:49 GMT

Check the obvious things first. Make sure the VBA environment is the same.
Security levels, Add-ins, references, etc. It may just be the Excel
configuraion.

Also try running the app on another Win 2000 machine to check for consistency

Signature

Gary''s Student - gsnu200753

> I build large spreadsheets for my clients. Recently a sheet that I built gave
> me a new problem. The sheet contains over 100 macros. I tested all of them,
[quoted text clipped - 4 lines]
> Professional. I have tried saving the sheet in earlier versions of Office,
> but that had no effect.

Reply to this Message