"Master (Callable) Macro File"

[moex201]

Is there anyway to use a macro from another spreadsheet in the current open spreadsheet?
I have about 9 files using pretty much the same functions, and when I want to update any of the functions I have to update all of the macros on 9 files to keep them in sync.
I think if I put all of the macro functions in one callable macro xls file, I can just set my other macros to call that file so I can update in one place.

Any Ideas anyone?

 

[gplhl]

Stick the Macro in your personal file

Personal.xls

 

[moex201]

Not sure what you mean. First of all I never used a "personal file" . But lets say I had a personal.xls. Where would I store it? Second , these excel files are on a server, so I have different people accessing them, so would I have to put my "personal.xls" file on the server?
And third, how would I call the functions from it's macro?

_________________
Give a carpenter a tool and he'll build a house, give a scientist a lab and he'll make a cure, give me a computer and I'll build you your application...
This message was edited by moex201 on 2002-03-06 07:53