Microsoft Office Tutorials and References
In Depth Information
To execute an instruction, press F8. The highlight moves to the next instruction, and your
worksheet then changes to reflect the action that resulted from executing the preceding
You can run a macro without stopping after each instruction by opening the Macro dialog
box, clicking the macro to run, and then clicking Run. You’ll usually run the macro this way;
after all, the point of using macros is to save time.
In this exercise, you’ll examine a macro in the Visual Basic Editor, move through the first
part of the macro one step at a time, and then run the entire macro without stopping.
SET UP You need the VolumeHighlights_start workbook located in your Chapter12
practice file folder to complete this exercise. Start Excel, open the VolumeHighlights_start
workbook, click the Enable Content button on the Message Bar (if necessary), and
save the workbook as VolumeHighlights . Then follow the steps.
1. On the View tab, in the Macros group, click the Macros arrow and then, in the list
that appears, click View Macros .
The Macro dialog box opens.
2. Click the HighlightSouthern macro, and then, to display the macro code, click Edit .
The Visual Basic Editor opens, with the code for the HighlightSouthern macro
displayed in the Module1 (Code) window.