- 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.
Sub SaveAllWorkbooks()
'Save all open workbooks.
Dim wb As Workbook
For Each wb In Workbooks
wb.Save
Next wb
End Sub
It'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!
Full Bio
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.