If it used on just your machine, use the "Personal Macro Workbook" which is
created the first time you record and save to this option. This workbook,
if it exists, is silently opened (remains hidden) with Excel and its modules
and code can be used in your other workbooks in the session. Take care with
naming conventions!

--

Regards,
Nigel




"Keith Howard" wrote in message
...
Hello.

Is there a simple way to create an Excel macro library? Basically, I just
want to store a number of macros in a module behind a workbook and have
the
public functions therein be available to be called from any other
workbook
that I happen to have open. (For clarity, I DO NOT want to duplicate code
into each workbook in which I need the relevant function.)

For now, I would like to avoid creating a proper add-in using the .net
framework.

Can I achieve my goal by creating an xlam file and including a reference
to
it from any workbook ? Or is there another simple approach?

Thank you.

Keith