Excel 2016 Macros

Lesson 1 - Using Macros

Excel 2016

Practice the Concept: Open the Trust Center again and change the Macro Settings to Disable all macros with notification.

A DDING A F OLDER AS A T RUSTED L OCATION  D ISCUSSION

The Macro-Enabled Workbooks that you save containing macros you created do not have a Digital Signature. When you open your Macro-Enabled Workbooks, the default security settings for macros will disable the macros and display a Security Warning in the Message Bar .

You could change the macro security settings to enable all macros but this, of course, creates a security risk. A far better method is to store all your Macro-Enabled Workbooks in a specific folder and add the folder to your Trusted Locations list. Files stored in your Trusted Locations are not security-checked by Excel and open without any prompts.

When you designate a folder as a Trusted Location, you can specify that subfolders within the designated folder should also be Trusted Locations . This makes it easy to have a structured folder system for storing your macros. If you have Macro-Enabled Workbooks stored in folders in different locations, you can add each of those folders to the Trusted Locations list.

You can also add a description to a folder when designating it as a Trusted Location to remind yourself about the contents of the folder. The description is visible only in the Trusted Locations list.

Adding a folder as a Trusted Location

Page 10

OFFICEPRO, Inc.