VBA Script useable by like workbooks

  • Thread starter Thread starter John Menken
  • Start date Start date
J

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