GrayJayBee:

I'm not sure of the implementation, but you might try playing with the
"XLSTART" directory ("x:\Documents and Settings\<username\Application
Data\Microsoft\Excel\XLSTART") -- .XLx sheets residing there are
automatically loaded whenever Excel starts up. I have two such files in my
XLSTART directory: GLOBAL.XLM and PERSONAL.XLS. They load macros accessible
at any time, from any sheet I'm working on at the time. You might try
sticking a sheet or macro file that loads your desired macros into this
directory, or insert a macro that opens your macro sheet into your users'
GLOBAL.xlm sheet.