What you are looking for is an add-in.

open your file, go to "save as..." and
choose .xla as file format. excel should
change the destination by itself and you
can save it directly there. close the
whole excel, open a new blank one and
go to "Tools" -- "add-ins" and you should
see your file in the list.

there are some better tutorials out the
http://www.ozgrid.com/VBA/excel-add-in-create.htm

hth

Carlo

On Nov 28, 8:40 am, wrote:
Hello,

I have an excel file holding a number of macros that I would like to
be able to access whenever excel is open. I have saved this file at C:
\Program Files\Microsoft Office\OFFICE11\xlstart. Now, when I open
excel, this file opens. However, I don't want the file to open, I just
want the macros in the file to be available.

Thanks,
Tom