Excel 2016 Macros

Excel 2016

Lesson 1 - Using Macros

Running a macro

NOTE You can also run macros by clicking the Macros button in the Code group on the Developer tab. 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. Select the View tab in the Ribbon .

3. Select the top part of the Macros button 4. Select the macro you want to run. 5. Select .

in the Macros group.



S TEP - BY -S TEP

Run a macro.

OFFICEPRO, Inc.

Page 17