Microsoft Office Tutorials and References
In Depth Information
Running macros when a button is clicked
TROUBLESHOOTING If macros in the workbook are not enabled, the SavingsHighlight
macro will not appear in the list.
6
Click Add to add the SavingsHighlight macro to the Customize Quick Access
Toolbar pane.
7
In the Customize Quick Access Toolbar pane, click the SavingsHighlight command.
8
Click Modify to open the Modify Button dialog box.
9
Click the gray button with the white circle inside it (the fourth button from the left on
the top row).
10
Click OK twice to close the Modify Button dialog box and the Excel Options dialog
box. The View Macros and SavingsHighlight buttons appear on the Quick Access
Toolbar .
11
On the worksheet, right-click the Show Efficiency shape, and then click Assign
Macro to open the Assign Macro dialog box.
12
12
Click EfficiencyHighlight , and then click OK to assign the macro to the button and
close the Assign Macro dialog box.
13
On the Quick Access Toolbar , click the SavingsHighlight button. Excel runs the
macro, which applies a conditional format to the values in the Savings column of the
table on the left.
 
Search JabSto ::




Custom Search