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

G

Gerri Reno

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.
 
G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top