Trust Center Settings

2. Try This: Edit the Trust Center Settings for Macros

Go to File ->Options.

Click on Trust Center.

Click on Trust Center Settings.

 

 

What Do You See? The Trust Center lets you review and edit the settings for  accepting macros from Trusted Publishers, Trusted Locations, and Trusted Documents. Microsoft, for example, is a Trusted Publisher with thousands of macro enabled templates on their websites.

 

The Macro Settings by default Disable all macros with notification. You can also choose to trust macros that have been digitally signed.

 

Microsoft does NOT recommend that you Enable all macros.

File ->Options->Trust Center-> Trust Center Settings

Exam 77-888: Microsoft Excel Expert 2010

4. Working with Macros and Forms

4.1. Create and manipulate macros: Enable Macros in a spreadsheet