ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   spreadsheet macros run fine at home, but not on other computer (https://www.excelbanter.com/new-users-excel/164669-spreadsheet-macros-run-fine-home-but-not-other-computer.html)

Gerri Reno

spreadsheet macros run fine at home, but not on other computer
 
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.

Gary''s Student

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.



All times are GMT +1. The time now is 08:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com