Macro's not working on different pc. Help!

[taansend]

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

 

[Harald Staff]

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

 

[K Dales]

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)