Microsoft Office Tutorials and References
In Depth Information
2. In the Macro Name box, type a name.
Make the name descriptive of what the macro does.
3. In the Shortcut Key box, type a letter (numbers or symbols won’t
When you press Ctrl plus that key, the macro plays back.
4. If you like, edit or add to the description of the macro.
This is especially useful if you think others will use it.
5. Select whether row and column references will be relative or
• Relative references: If you select (say) the task in the third row
displayed in a sheet and perform an action on it, Project selects the
task in the third row whenever you run the macro.
• Absolute references: Project selects a specific, named task, no
matter what row it occupies.
6. Click OK to begin recording.
Every keystroke you make during this time becomes part of the macro.
7. After you complete your keystrokes, choose Tools
Here are some points to keep in mind about recording macros:
Naming: Macro names have to start with a letter and can’t contain
spaces. Use the underscore to separate words in a macro name
(Weekly_Report, for example).
Keystroke presets: Several keystroke shortcuts are already reserved by
Project for use with built-in functions. For example, pressing Ctrl+K
inserts a hyperlink. Project displays a message telling you this if you
choose such a shortcut and then gives you an opportunity to choose
another letter or number.
Entering unique information: If what you record includes entering
specific information (such as a name or a date range), you’re presented with
a blank box into which you enter new information when you run the
macro — even if you entered information while recording the macro.
Running and editing macros
To run a macro, your best bet is to use the shortcut key that you entered
when you created it. (See the preceding section.) This two-keystroke
combination runs the macro, pausing for you to fill in any requested information.