See help on Personal Macro Workbook for making macros available for
all workbooks.

Also consider storing your macros in a new workbook and saving that
workbook as an Add-in.

I consider the Add-in route as the best way.



Gord


On Mon, 14 Nov 2011 07:01:06 -0800 (PST), John Menken
wrote:

I'm just learning VBA for use with Excel 2007.
What is the best way to make a script available to other workbooks of
a similar type?
Thank you.