Cyberdude
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?
Sid
"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?
Sid