Hello, all!

I'm trying to build a centralized "collection" of macros that I can reference from a large number of different workbooks. The reason for this is because we have several dozen local phone bills that we use some of these macros in, and if we ever make a change to the routines we'd rather not have to make the same change in every single bill's workbook.

Now, I know that I can set up the Personal.xlsb file with macros in it on a given computer. Alternately, I can always create a workbook ("Macros.xlsm" or something) and open that at the same time. However, since we may be running these macros from different computers, the Personal workbook won't really work too well, and I'd rather avoid having a "source" workbook opened up if I can avoid it, so that I don't have conflicts if two people are trying to fill out different bills at the same time.

Does anybody know a way to create a macro module that can be accessed from any open file, without having to open up the workbook that it's in? Or should I just learn to stop worrying and make a policy that only one person should be working on the bills at a time?