Excel 2016 Macros

Excel 2016

Lesson 1 - Using Macros



P ROCEDURES

1. Select the File tab

.

2. Select Options . 3. Select Trust Center from the list in the left-hand pane.

4. Select in the right-hand pane. 5. Select Macro Settings from the list in the left-hand pane. 6. Select the desired option in the Macro Settings section of the page. 7. Select . 8. Select .



S TEP - BY -S TEP Change macro security settings.

Steps

Practice Data

1. Select the File tab . The Backstage view opens.

Click

2. Select Options . The Excel Options dialog box opens. 3. Select Trust Center from the list in the left-hand pane. A page with information about privacy and security appears in the right-hand pane. 4. Select the Trust Center Settings button in the right-hand pane. The Trust Center dialog box opens. 5. Select Macro Settings from the list in the left-hand pane. The Macro Settings page is displayed in the right-hand pane. 6. Select the desired option in the Macro Settings section of the page. The desired option is selected. 7. Select OK . The selection is confirmed and the Trust Center dialog box closes. 8. Select OK . The Excel Options dialog box closes.

Click Options

Click Trust Center

Click

Click Macro Settings

Click

Disable all macros

except digitally signed macros

Click

Click

OFFICEPRO, Inc.

Page 9