Excel 2016 Macros

Excel 2016

Lesson 1 - Using Macros

NOTE To remove a folder from the Trusted Locations list, open the Trust Center and display the Trusted Locations page. In the list of Trusted Locations, select the folder you wish to remove and click the Remove button. To make changes to a folder in the Trusted Locations list, open the Trust Center and display the Trusted Locations page. In the Trusted Locations list, select the folder you wish to change and click the Modify button. You can designate a different folder by changing the path, allow or disallow subfolders, and change the description. You can also disable all Trusted Locations. In the Trusted Locations page in the Trust Center , select the Disable all Trusted Locations. Only files signed by Trusted Publishers will be trusted option. Preferably, the folders you add to the Trusted Locations list should be on the local hard disk of your computer. If the folder resides on a network drive, it should be a folder with limited access. You should not designate a public folder on a network drive as a Trusted Location . The more people who have access to the folder, the more danger there is that someone could tamper with your 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 Trusted Locations from the list in the left-hand pane.

6. Select

.

7. Select . 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. 9. Open the folder you want to add to the Trusted Locations list. 10. Select the left-hand part of the OK button . 11. Select Subfolders of this location are also trusted , if required. 12. Select the Description box. 13. Type a description of the folder or its contents. 14. Select . 15. If the folder you added resides on a network drive, select Allow Trusted Locations on my network (not recommended) .

OFFICEPRO, Inc.

Page 11