Sending them your personal.xls is very dangerous as they may already have
one that does stuff.

You can export the code via the VBE (Alt+F11) and right click on the modules
and select export and vice versa on their machine. You need to be aware
that some stuff may not work if their machine is not set up similarly to
yours, e.g ODBC, versions, etc.

The safest way is to write code and save it as an add-in. This way they can
load in via ToolsAdd-Ins... and there will be no macro warning, etc. The
code needs to be written to the same rules as all other code though, (as
above)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"Jugglertwo" wrote in message
...
I would like to share some macros with my co-workers. Presently, I have
several that I have saved in the Personal.xls workbook.
1) What is the best way to share these macros with them?
2) I know that the Personal.xls workbook is saved in the XLSTART folder.
Do
I just send them a copy of this workbook as an attachment and have them
put
this file in their XLSTART folder?
3) Am I asking for trouble if I attend to share macros at work?
Any info and/or suggestions would be greatly appreciated !
Jugglertwo