Macro's not working on different pc. Help!
Hello,
I have written a large spreadsheet containing several macro's. Thes all work great on my pc. However, when I forward them to a colleagu the macro's cease working and require debugging. Does anyone have any tips on to avoid this? Many thanks in advance. Jonny Townsen -- Message posted from http://www.ExcelForum.com |
Macro's not working on different pc. Help!
Hi Jonny
On a not-working-so-well Pc, open the VB editor, choose Tools References and uncheck everything marked "Missing". It may or may not work after that, depending on what's missing. HTH. Best wishes Harald "taansend " skrev i melding ... Hello, I have written a large spreadsheet containing several macro's. These all work great on my pc. However, when I forward them to a colleague the macro's cease working and require debugging. Does anyone have any tips on to avoid this? Many thanks in advance. Jonny Townsend --- Message posted from http://www.ExcelForum.com/ |
Macro's not working on different pc. Help!
What happens when your colleague tries to run them? Any
error messages? Would really help to know. Possible issues to check (some obvious): 1) Is colleague using the same version of Excel? Windows? 2) Is macro security set high? (will prevent macros from running) 3) Do macros contain references? Are same references set on colleague's machine? 4) For references, do necessary library files exist on colleague's machine? (when setting up the references, the file name/path shows in the dialog box at the bottom - check to see if the same file - and same version - exist in the same path) -----Original Message----- Hello, I have written a large spreadsheet containing several macro's. These all work great on my pc. However, when I forward them to a colleague the macro's cease working and require debugging. Does anyone have any tips on to avoid this? Many thanks in advance. Jonny Townsend --- Message posted from http://www.ExcelForum.com/ . |
All times are GMT +1. The time now is 12:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com