Excel Macro

[Centrol]

After creating a macro in 'Book1', what must I do to make the macro
available in all workbooks & sheets automatically?

 

[Gary''s Student]

Include the macro in your personal.xls file.

 

[Bob Phillips]

or create an addin


http://msdn.microsoft.com/library/d...ml/deovrbuildingapplicationspecificaddins.asp
Building Application Specific Add-Ins

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/deovrexceladdins.asp
Excel Add-Ins

http://msdn.microsoft.com/library/d...html/deovraddinstemplateswizardslibraries.asp
Add-ins, Templates, Wizards, and Libraries