C Centrol Oct 27, 2008 #1 After creating a macro in 'Book1', what must I do to make the macro available in all workbooks & sheets automatically?
After creating a macro in 'Book1', what must I do to make the macro available in all workbooks & sheets automatically?
B Bob Phillips Oct 27, 2008 #3 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
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
