Creating an Excel macro library

  • Thread starter Thread starter Keith Howard
  • Start date Start date
K

Keith Howard

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
 
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!
 
Back
Top