Word Document Properties

Chapter 3: Writing Structured VBA Programs
08_046500 ch03.qxp 12/5/06 5:34 PM Page 57

---

8. Click Stop Recording.
The Office application finishes the macro. The Stop Recording toolbar
disappears.
You can see your new macro by choosing Tools
➪
Macro
➪
Macros. The Macro
dialog box contains a list of the macros associated with the current docu-
ment, whether they’re local or part of another document, stencil, template,
or other associated file.
Although this book proper doesn’t contain much material on Visio or
FrontPage, you’ll find a Visio Bonus Chapter on the Dummies.com Web site.
Visit 
www.dummies.com/go/vbafd5e
to download both the source code
and the Bonus Chapters (one for Visio and another for FrontPage).
Modifying the macro
Modifying a macro recorded using the Macro Recorder is much like modifying
any other macro. The only differences are that you didn’t write the initial code
and the Macro Recorder doesn’t add any comments for you. As an example,
open the Excel macro created earlier in this chapter, in the “Recording a
macro using the Ribbon interface” section. The following steps describe how
to perform this task:
1. Open the Macro dialog box. When using the Ribbon interface, you
click Macros on the Developer tab. When using the menu interface,
choose Tools
➪
Macro
➪
Macros.
You see the Macro dialog box, shown in Figure 3-4.
2. Choose the macro you want to edit and then click Edit.
The Office application opens the Visual Basic Editor with the selected
macro opened, as shown in Figure 3-5. (You may see other macros files
opened as well.)
3. Add comments to the recorded macro so that you can retrace your
steps later.
Stop Recording
Pause Recording