Microsoft Office Tutorials and References
In Depth Information
Using the Macro Recorder
A shortcut key is not mandatory; in fact, most of your macros will not have one
or need one. But if you do want to assign a shortcut key, get into the good habit
of assigning it with the Ctrl+Shift combination rather than with just the Ctrl
key. Excel has assigned almost all 26 letters of the alphabet to serve as shortcuts
with the Ctrl key for various tasks, and you will do well to avoid overriding that
built-in functionality. For example, Ctrl+C is typically the key combination you
use to copy text. However, if you assign the shortcut key Ctrl+C to your macro,
you will override the default for that key combination and will not be able to use
Ctrl+C to copy text.
To take advantage of the Shortcut Key option, click in the Shortcut Key field, press the Shift key,
and also press a key such as the letter S. You will have created the keyboard shortcut Ctrl+Shift+S,
which will not interfere with any of Excel’s significant built-in keyboard shortcuts.
Most macros you record will be stored in the workbook you are working with. For now, you can
keep the default selection of This Workbook in the Store Macro In field.
Finally, in the Description field, enter a brief but meaningful explanation of what the macro does.
When you are finished making these minor changes to the Record Macro dialog box, it will look
similar to Figure 2-13. Go ahead and click OK, which will turn on the Macro Recorder, and you
can proceed to manually perform the steps you want to automate.
In versions 2003 and before, you will see a tiny floating toolbar while the Macro
Recorder is on. That is the Stop Recording toolbar, with a Stop Recording
button you will click when you are finished recording your actions. When you
have completed the steps to your task, turn off the Macro Recorder in version
2003 by clicking the Stop Recording button, as shown in Figure 2-14.