Microsoft Office Tutorials and References
In Depth Information
In this exercise, you’ll add the View Macros button to the Quick Access Toolbar, add a
macro button to the Quick Access Toolbar, assign a macro to a workbook shape, and
then run the macros.
SET UP You need the PerformanceDashboard_start workbook located in your Chapter12
practice file folder to complete this exercise. Open the PerformanceDashboard_start
workbook, click the Enable Content button on the Message Bar (if necessary), and save
the workbook as PerformanceDashboard . Then follow the steps.
1. On the Quick Access Toolbar, click the Customize Quick Access Toolbar button,
and then click More Commands .
The Customize The Quick Access Toolbar page of the Excel Options dialog box opens,
displaying the Popular Commands category in the Choose Commands From pane.
2. In the list of available commands, click View Macros .
3. Click Add .
The View Macros command appears in the Customize Quick Access Toolbar pane.
4. In the Choose commands from list, click Macros .
The available macros appear in the pane below.
5. In the Choose commands from pane, click SavingsHighlight .
Troubleshooting If macros in the workbook are not enabled, the SavingsHighlight
macro will not appear in the list.