Excel 2016 Macros

Lesson 2 - Recording Macros

Excel 2016

The Record Macro dialog box

NOTE If you record a macro to the Personal Macro Workbook , you are prompted to save the changes when you exit Excel. To use the Developer tab, you should ensure that the Show Developer in the Ribbon option is selected. This option is located in the Popular page of the Excel Options dialog box. You can also open the Record Macro dialog box by selecting the bottom part of the Macros button on the View tab and then clicking Record Macro . Some words are reserved and cannot be used in a macro name. Invalid words are usually macro commands, such as Date or If .



P ROCEDURES

1. Select the Developer tab on the Ribbon . 2. Select in the Code group. 3. Type the desired macro name.

4. Select the Shortcut key box, if desired. 5. Type the desired shortcut key character. 6. Select the Store macro in list. 7. Select the desired location in which to store the macro. 8. Select the Description box.

OFFICEPRO, Inc.

Page 29