I wouldn't mess around with replacing others' Personal.xls files which may
contain their own macros.

You can stick all your macros into one module in Personal.xls then export that
as a *.bas file.

Send that to them by email and they can import that *.bas file as a module into
their Personal.xls file.

Or Save As Personal.xls as an add-in(*.xla) and send that to them so's they can
load it through ToolsAdd-ins.


Gord Dibben MS Excel MVP


On Wed, 20 Jun 2007 14:54:50 -0700, Jugglertwo
wrote:

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