- Click the drop-down arrow at the right end of the QAT and choose More Commands.
- Choose Commands Not In The Ribbon from the Choose Commands From drop-down list.
- Scroll down and select Save All.
- Click Add and then click OK.
'Save all open workbooks.
Dim wb As Workbook
For Each wb In Workbooks
End SubIt's easy to add a macro to the QAT. Use the above instructions, except in step 2, choose Macro. Then, highlight the macro in question. Have you added any macros to the QAT? Consider starting a new thread and sharing those macros with the rest of us!
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.