Microsoft Office Tutorials and References
In Depth Information
See Also For more information about customizing the Quick Access Toolbar, see “Customizing
the Excel 2010 Program Window” in Chapter 1, “Setting Up a Workbook.”
When you display the Popular Commands command group, you’ll see that the last item
in the command pane is View Macros. When you click the View Macros item, click the
Add button, and then click OK, Excel adds the command to the Quick Access Toolbar and
closes the Excel Options dialog box. Clicking the View Macros button on the Quick Access
Toolbar displays the Macro dialog box, which saves a significant amount of time compared
to displaying the View tab and moving the mouse to the far right edge of the ribbon.
If you prefer to run a macro without having to display the Macro dialog box, you can
do so by adding a button representing the macro to the Quick Access Toolbar. Clicking
that button runs the macro immediately, which is very handy when you create a macro
for a task you perform frequently. To add a button representing a macro to the Quick
Access Toolbar, click the Customize Quick Access Toolbar button at the right edge of
the Quick Access Toolbar, and then click More Commands to display the Customize The
Quick Access Toolbar page of the Excel Options dialog box. From there, in the Choose
Commands From list, click Macros. Click the macro you want represented on the Quick
Access Toolbar, click Add, and then click OK.
Search JabSto ::

Custom Search