Calling macros in another spreadsheet
 

Larry,

Store the file centrally.
Then in each of the user's files, create either a form
button or a toolbar button, and assign it to the macro in
the file stored centrally. (make sure the central file is
open. makes assigning the macro easier.)

HTH's.
Russ.

-----Original Message-----
I have a spreadsheet that the user will need to run a
macro against to update it with current data. The user
will save and reuse the same spreadsheet each time,
running the macro whenever they need an update. I want
to
make sure the user always gets the most recent version of
the update code. I was thinking of putting the code that
updates the spreadsheet in second, centrally stored,
spreadsheet that is called by the first. Does anyone
have
suggestions on how I can have just a "stub" in the user's
spreadsheet that calls the real code that is stored
separately?
.