This week, show off your Excel expertise and learn the solution to last week's missing Save All command in the 2007 applications.
- 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!