View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default spreadsheet macros run fine at home, but not on other computer

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
--
Gary''s Student - gsnu200753


"Gerri Reno" wrote:

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.