Microsoft Office Tutorials and References
In Depth Information
Record a Macro
Chapter 11: Learning VBA Basics
The Recording icon
appears in the status bar.
8 Perform the Excel steps
you want to record.
9 Click the Recording icon.
Excel stops the macro
recorder and saves the
macro in the workbook
that you selected in step 5.
Did You Know?
When you specify the macro name in
step 4, keep in mind that there are a
few restrictions you must observe. For
example, the name must be no longer
than 255 characters; the name must
begin with either a letter or an
underscore (_); the name cannot
contain a space or a period; and the
name cannot be the same as an
existing Excel function.
You can also start a recorded macro using the
Ribbon’s Developer tab, which is not
displayed by default. To display it, right-click
the Ribbon, click Customize the Ribbon, click
to select the Developer check box, and then
click OK. To start a macro recording, click the
Developer tab and then click Record Macro.
You can also use the Developer tab to open
the VBA Editor, as described in the section,
“Open the VBA Editor.”