Distributing Macro's in Excel

[paul_sedman]

First of apologies if this seems like a newbie question it is.
I have written a macro/form that imports a text file and formats it into a report. I now want to distribute this macro to a few people. I have exported it to a file. everytime I want to use it I have to re-import it. Is there a single macro repository that I can save all macros to and have them available whenever I open a new copy of Excel?
Thanks a lot.
This message was edited by paul_sedman on 2002-09-24 17:10

 

[Paul B]

if you save it in your perosnal.xls it will be available to all of your workbooks