Excel 2016 Macros

Lesson 1 - Using Macros

Excel 2016

Steps

Practice Data

Click the student data drive

4. From the left side of the screen, select the drive in which the workbook you want to open is located. A list of available folders appears. 5.Open the folder in which the workbook you want to open is located. The contents of the folder appear. 6. Select the file name of the workbook you want to open. The file name is highlighted in the list and appears in the File name box. 7. Select the left-hand part of the Open button. The Open dialog box closes, the workbook opens and the Message Bar opens above the workbook with a Security Warning displayed. 8. Select the desired option. The desired option is selected.

Double-click to open the student data folder

Scroll as necessary and click CITY56.XLSM

Click

Click

R UNNING A M ACRO  D ISCUSSION

Macros are saved in modules, and both are saved with the workbook in which they were written. Before you can run a macro, the workbook in which it is saved must be open. When you select a macro from the Macro dialog box, Excel performs its commands in sequence.

Macros in any open workbook can be run from any other open workbook.

Page 16

OFFICEPRO, Inc.