Excel 2016 Macros

Lesson 1 - Using Macros

Excel 2016

16. Select

.

17. Select

.



S TEP - BY -S TEP Add a folder to the Trusted Locations list.

Steps

Practice Data

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

Click

2. Select the Options button. 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 Trusted Locations from the list in the left-hand pane. The Trusted Locations page is displayed in the right-hand pane. 6. Select the Add new location button. The Microsoft Office Trusted Location dialog box opens. 8. From the left side of the screen, select the drive in which the folder you want to add to the Trusted Locations list is located. A list of available drives and common folders appears. 9. Select the drive in which the folder you want to add to the Trusted Locations list is located. A list of available folders appears. 7. Select the Browse button. The Browse dialog box opens.

Click Options .

Click Trust Center

Click

Click Trusted Locations

Click

Click

Click the folder to add.

Click the student data drive

Page 12

OFFICEPRO, Inc.