Recording options
Whenever we record a macro, there are a number of options to consider. Beyond the choice between absolute and relative references, there are other settings we need to take note of.
In this recipe, we will be looking at different options when recording a macro.
Getting ready
Open Excel and make sure that Book1 is active.
How to do it…
Here are the steps to set options for recording a macro:
- With Sheet1 active, click on Developer | Code | Record Macro. The Record Macro dialog box appears:
Figure 5.5 – The Record Macro dialog box
- The Macro name, Shortcut key, Store macro in, and Description options can all be changed, based on personal choice and need.
How it works…
The details of each option will now be discussed in the following subsections.
Macro name
All macros must have a name. There is, however, a specific naming convention that we need to follow. Macro names follow these conventions:
- Must begin...
