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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top