The Macro Recorder dialog box
There are 4 options to complete in this dialog box:
- Macro name - give your macro a descriptive name. The name must begin with a letter and spaces are not allowed. Only letters, numbers and the underscore character are permitted.
- Shortcut key - (optional) fill in a letter, number, or other character in the available space. This will allow you to run the macro by holding down the CTRL key and pressing the chosen letter on the keyboard.
- Store macro in
- Options:
- This workbook
- The macro is available only in this file.
- New workbook
- This option opens a new Excel file. The macro is available only in this new file.
- Personal macro workbook.
- This option creates a hidden file Personal.xls which stores your macros and makes them available to you in all Excel files.
- This workbook
- Description - (optional) enter a description of the macro.
For this tutorial:
- Set the options in the Record Macro dialog box to match those in the image above.
- Do Not click OK - yet - see below.
- Clicking the OK button in the Record Macro dialog box starts recording the macro you have just identified.
- As previously mentioned, the macro recorder works by recording all keystrokes and clicks of the mouse.
- Creating the format_titles macro involves clicking on a number of format options on the home tab of the ribbon with the mouse while the macro recorder is running.
- Clicking the OK button in the Record Macro dialog box starts recording the macro you have just identified.
- Go to the next step before starting the macro recorder.
