Microsoft Office Tutorials and References
In Depth Information
If you record all those keystrokes, you have to go through a ten-step process.
But, after they’re recorded, that process is reduced to three steps when you
play back the macro.
1. Start your macro.
2. Enter the first part of the date range.
3. Enter the last part of the date range.
One great use I’ve seen for macros is to copy a range of tasks that is repeated
again and again in your project — for example, a Q&A procedure that’s
repeated ten times throughout a project. In recording the macro, just select
the absolute range and copy it, go to the first blank task and paste it, ten
times. While the macro’s running, you can go get yourself another cup of
Recording a macro
Recording a macro is a simple process: You just start recording, do whatever
you usually do to perform the action, and then stop recording. You run
macros by selecting them from a list of macros or by using a keystroke
shortcut. You also can edit them if you need a slightly different series of keystrokes
for a slightly altered sequence of steps.
Here’s how you record a macro:
1. Choose Tools
Record New Macro.
The Record Macro dialog box appears, as shown in Figure 17-5. Macros
that you record can be played back by using a shortcut key that you