Microsoft® Office Excel® 2007 Inside Out

Using the Macro Recorder

To make the macro recorder accessible, you need to display the Developer tab on the Ribbon. Click the Microsoft Office Button, and then click Excel Options. In the Popular category, select the Show Developer Tab In The Ribbon check box, and then click OK. To start the macro recorder, click Record Macro in the Code group on the Developer tab.

Note

After you have exercised the option to include the Developer tab on the Ribbon, the Record Macro button appears on the status bar next to the word Ready as well as in the Code group on the Developer tab. It remains accessible there even if you subsequently clear the Show Developer Tab In The Ribbon check box in the Excel Options dialog box. You’ll probably want to keep the Developer ...