Word Document Properties

Part II: Learning the Ropes 
08_046500 ch03.qxp 12/5/06 5:34 PM Page 54

---

1. Select the Developer tab.
Because Office 2007 doesn’t display this tab by default, see the “Batteries
Included — VBA Comes with Office” section of Chapter 1 for details on
displaying it.
You see the Developer tab, shown in Figure 3-1.
2. Click Record Macro.
The Office application displays the Record Macro dialog box, shown in
Figure 3-2.
3. Type a descriptive name for the macro.
4. Type a control-key combination for the macro when you want to
access it from the keyboard.
Use this option only for major macros because you don’t want to use up
all of the available key combinations.
Figure 3-2:
Use the
Record
Macro
dialog box
to type
details
about your
macro.
Figure 3-1:
The
Developer
tab contains
most of the
items you
need to
work with
macros.
55
Chapter 3: Writing Structured VBA Programs
08_046500 ch03.qxp 12/5/06 5:34 PM Page 55

---

5. Select a storage location in the Store Macro In field.
The storage locations vary by Office application. Here’s an explanation
of the locations for Excel:
•
This Workbook:
Use this option when you want to store the macro
within the local file. Anyone opening the file can access the macro.
•
Personal Macro Workbook:
Use this option when you want to
store the macro in a special workbook that contains all of your 
personal macros. This storage location makes the macro available
to you at all times. It doesn’t matter which workbook you open.
•
New Workbook:
Use this option when you want to store the macro
in a new workbook.
The storage locations for Word are similar, as explained in the follow-
ing list:
•