View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Central Macro Workbook


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.