saving macros to a common folder for all users

[Helen]

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