Microsoft Office Tutorials and References
In Depth Information
9. Click the Visual Basic Editor Close button.
A warning dialog box opens, indicating that closing the Visual Basic Editor will stop
10. Click OK .
The Visual Basic Editor closes.
11. In the Macros list, click View Macros .
The Macro dialog box opens.
12. Click the HighlightSouthern macro.
13. Click Run .
The Macro dialog box closes, and Excel runs the entire macro.
14. On the Quick Access Toolbar, click the Save button.
Excel saves your work.
CLEAN UP Close the VolumeHighlights workbook.
Creating and Modifying Macros
The first step of creating a macro is to plan the process you want to automate. Computers
today are quite fast, so adding an extra step that doesn’t affect the outcome of a process
doesn’t slow you down noticeably, but leaving out a step means you will need to re-record
your macro. After you plan your process, you can create a macro by clicking the View tab
and then, in the Macros group, clicking the Macros arrow. In the list that appears, click
Record Macro. When you do, the Record Macro dialog box opens.