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