Make a macro created in VBE available in all workbooks

  • Thread starter Thread starter Robert
  • Start date Start date
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
 
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. ???
 
Back
Top