Creating an Excel macro library

[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

 

[Nigel]

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!

 

[Ron Rosenfeld]

Can I achieve my goal by creating an xlam file and including a reference to
it from any workbook ?

Yes, and that is what I do.
--ron

 

[Jacob Skaria]

Excel Add-In do not require .NET Framework.

http://www.ozgrid.com/VBA/excel-add-in-create.htm

If this post helps click Yes

 

[Ron de Bruin]

Try this one for 2007
http://www.rondebruin.nl/qat.htm

Very easy to create a nice menu