if you set up a common location on the network, then go to each machine and
put the path to this location in the Alternate Startup Location in
Tools=Options = General.

Put the macros in any workbook (don't name it personal as they might have
their own). Hide the workbook and then save it to this location. Use
Windows Explorer (properties - attributes) to make the workbook Read-Only.

Then when Excel is loaded, this workbook should be loaded as well.

Regards,
Tom Ogilvy


"daria" wrote in message
...
I can save Macro's by attaching to the workbook its used
in or in my personal folder. I am trying to find out how
to save macro's in a common personal folder for all users
in the office. The save in macros doesn't allow one to
browse out. Let me know, Daria