The Macro Recorder dialogue box
Note: For help on these steps, refer to the image above.
There are 4 options to complete in this dialog box:
- Name – give your macro a descriptive name.
- Shortcut key - (optional) fill in a letter 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:
- the current workbook
- The macro is available only in this file.
- a new workbook
- This option opens a new Excel file. The macro is available only in this new file.
- a 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.
- the current workbook
- Description - (optional) enter a description of the macro.
