Datasheet
8
7
1
2
3
4
5
6
The Record Macro dialog box
appears.
3 Type the name you want to give
your macro.
4 Type the shortcut key you want to
assign to your macro.
Press Shift as you type to assign
an uppercase key.
5 Click the down arrow and then
select the workbook in which you
want to store your macro.
6 Type a description of your macro.
7 Click OK.
1 Click the Developer tab.
Note: See the section “Introducing
Macros” to learn how to display the
Developer tab.
•
Alternatively, click the Record
Macro button on the status bar
and skip Step 2.
2 Click Record Macro.
Record a Macro
A
macro enables you to automate common tasks.
You can use a macro to record most of the series
of commands you can execute in Excel. For
example, if you frequently apply a certain format to your
worksheet, you can record the steps for creating the
format and then play them back each time you want to
apply the format.
Clicking the Macro Recorder button opens the Record
Macro dialog box. You can use the Record Macro dialog
box to name your macro, assign your macro to a shortcut
key, and tell Excel where you want to store your macro.
You can name your macro anything you want; however,
the name must start with a letter; only contain letters,
numbers, and underscores; and not contain any spaces.
You can assign any upper- or lowercase letter to act as
the shortcut key.
In the Record Macro dialog box, the Store Macro In field
tells Excel where to store your macro. You can choose to
store your macro in the Personal Macro Workbook, a New
Workbook, or This Workbook. Use the Personal Macro
Workbook option if you want to make your macro
available to all Excel files. After you have stored at least
one macro in the Personal Macro Workbook, the
workbook opens whenever you open an Excel file. Use
the New Workbook option if you have specialized macros
that you want to use with multiple files. If you store your
macro in a New Workbook, you can use the macros
whenever that workbook is open. Use the This Workbook
option if you want to store your macro in the workbook
in which you are currently working.
Record
a Macro
03_591598-ch01.indd 803_591598-ch01.indd 8 6/11/10 1:41 PM6/11/10 1:41 PM