Excel 2016 Macros

Excel 2016

Lesson 1 - Using Macros

NOTE For this topic to work properly, macro security must be set to the default setting. To check and, if necessary, set the correct option, select the File tab , the Excel Options button, the Trust Center page, and the Trust Center Settings button. Then, select the Disable all macros with notification option and OK twice.



P ROCEDURES

1. Open a workbook containing macros and enable the macros. 2. Press the shortcut key assigned to the macro.



S TEP - BY -S TEP Use a shortcut key to run a macro.

If necessary, enable the macros.

The shortcut key for this macro is the lowercase letter n .

The macro used in the following steps directions opens the NEWYORK.XLSX workbook but does not contain a file path. As a result, it will look in the current folder for the file. If you opened the CITY56.XLSM file by selecting it from the recently used files list, the current folder may not be the folder that contains the NEWYORK.XLSX file. Make sure that your current folder is set for the path containing the student data files by using the Open command in the File tab to open the CITY56.XLSM file.

Steps

Practice Data

1. Press the shortcut key assigned to the macro. The macro runs.

Press [Ctrl+n]

Close the NEWYORK.XLSX workbook.

D ISPLAYING THE D EVELOPER T AB  D ISCUSSION The Developer tab provides a variety of buttons that can be used when creating, editing, or running macros.

OFFICEPRO, Inc.

Page 19