Nice article, but it looks like I'd still need to manually install the macro
on each user's PC. Would an add-in file also contain custom toolbars?

"Bob Phillips" wrote:


http://support.microsoft.com/default.aspx?kbid=211563
How to create an add-in file in Excel 2000



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Nicholas Wautier" <Nicholas wrote in
message ...
Is there any way to have one central workbook of macros for an entire
office?
I am writing a series of formating and quoting macros for my office, but
will not be able to go to each person's computer to copy the code and make
the nessicary toolbar additions. Even if we don't "share" a work book, I
need to find a way to get the code distributed, any and all suggestions
would
be much appreciated!

P.S. My office is still using Office 2000 SP3.