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