or create an addin


http://msdn.microsoft.com/library/de...ificaddins.asp
Building Application Specific Add-Ins

http://msdn.microsoft.com/library/de...xceladdins.asp
Excel Add-Ins

http://msdn.microsoft.com/library/de...slibraries.asp
Add-ins, Templates, Wizards, and Libraries

--
__________________________________
HTH

Bob

"Gary''s Student" wrote in message
...
Include the macro in your personal.xls file.
--
Gary''s Student - gsnu2007k


"Centrol" wrote:

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