Microsoft Office Tutorials and References
In Depth Information
Running macros when a button is clicked
Running macros when a button is clicked
You can quickly discover the commands built into Excel by looking though the commands
on the ribbon. However, it can take a few seconds to display the View tab, open the Macro
dialog box, select the macro you want to run, and click the Run button. When you’re in the
middle of a presentation, taking even those few seconds can reduce your momentum and
force you to regain your audience’s attention. Excel offers several ways for you to make
your macros more accessible.
If you want to display the Macro dialog box quickly, you can add the View Macros button to
the Quick Access Toolbar. To do so, click the Customize Quick Access Toolbar button at the
right edge of the Quick Access Toolbar, and then click More Commands to display the Quick
Access Toolbar page of the Excel Options dialog box.
SEE ALSO For more information about customizing the Quick Access Toolbar, see
“Customizing the Excel 2013 program window” in Chapter 1, “Setting up a workbook.”
In the Popular Commands command group, the last item in the command pane is View
Macros. When you click the View Macros command, 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 opens the Macro
Search JabSto ::




Custom Search