View Full Version : Adding a Macro to the QAT

01-18-2010, 11:03 AM
In John Walkenbach's book "Excel 2007 Power Programming with VBA" he answers the question "How do I add a macro to the QAT?" as follows:

"Right click the QAT and choose Customize Quick Access Toolbar from the shortcut menu. In the Customize tab of the Excel Options dialog box, choose Macros from the dropdown list on the left. Select your macro and click Add. To change the icon or text displayed, click the Modify button."

This looks like it might be handy except when I look for "Macros" in the dropdown list of the left, I don't see it as one of the choices. Did John maybe screw up, or did Microsoft delete the "Macros" option?

01-20-2010, 06:15 AM
I found that it works

The attachment has screen shots, etc.


01-21-2010, 01:23 PM
Thank you, Paul. I seem to have a hard time finding things in Win 7, but thanx to you I found the macros button. Nice attachments.