VBA Script useable by like workbooks

[John Menken]

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.

 

[Gord Dibben]

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