Excel 2016 Macros

Lesson 2 - Recording Macros

Excel 2016

Steps

Practice Data

7. Select the desired location in which to store the macro.

Click This Workbook

The location appears in the Store macro in box.

8. Select the Description box.

Press [Tab]

The insertion point is placed in the Description box.

9. Type the desired macro description. The text appears in the Description box.

Type Opens the Chicago workbook

10. Select OK .

Click

The Record Macro dialog box closes. The Record Macro button in the Code group changes to the Stop Recording button and a Stop Recording button is also displayed on the status bar. procedure that you want to automate. The procedure is carried out and recorded. 12. When you have finished recording macro steps, click the Stop Recording button in the Code group. The macro recorder stops. The Record Macro button displays again and the macro recording is complete. 11. Perform the steps in the

Follow the instructions shown below the table before continuing to the next step

Click

Perform the following steps to create the macro:

Click the File tab and then select Open from the Office menu. Double-click CHICAGO.XLSX in the student data folder.

Return to the table and continue step 12.

OFFICEPRO, Inc.

Page 31