Make a macro created in VBE available in all workbooks

[Robert]

How and where do I save an Excel 2007 macro to make it available in all
workbooks?

 

[Robert Flanagan]

You can save it in your personal.xls workbook. If you do not have one, just
record a simple macro and specify that it is to be recorded in personal.xls

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Robert]

Thanks Robert,
Macro works in all workbooks but, now to close Excel I have to click Close
btn (upper right) twice to close application. The first click closes the
workbook and second click closes App. If I remove the macro, App. closes on
first click. ???