saving macros to a common folder for all users
 

Try this:

Create a folder on the server called Common and save an
Excel spreadsheet with all the macros in this new folder.
For each user, open Excel and from the Tools menu, select
Options. On the General tab, click in Alternate Startup
File Location and type in the path to the new folder. The
spreadsheet will open and be hidden every time they open
Excel.

Hope this helps,
Helen


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