Microsoft Office Tutorials and References
In Depth Information
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 workbook located in the Chapter12 practice
file folder to complete this exercise. Open the workbook, click the Enable Content
button on the Message Bar (if necessary), and then follow the steps.
On the View tab, in the Macros group, click the Macros arrow and then, in the list
that appears, click View Macros to open the Macro dialog box.
If necessary, 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.
In the Visual Basic Editor window, click the Close button to close the window and
redisplay the workbook.
In the Macros list, click View Macros to open the Macro dialog box.
Click the HighlightSouthern macro, and then click Step Into . The macro appears in
the Visual Basic Editor, with the first macro instruction highlighted.