Welcome to the leading Managed IT Services, Small Business IT Support and Calgary's Leading Non profit IT Support company.

Recent Posts

December 2018
M T W T F S S
« Nov    
 12
3456789
10111213141516
17181920212223
24252627282930
31  

Call for Support or Free Consultation Tel: (403)453-5854 Toll Free: (888) 298-2092 Client Login

Enable or disable macros in Office files

Enable macros when the Message Bar appears

When you open a file that has macros, the yellow message bar appears with a shield icon and the Enable Content button. If you know the macro, or macros, are from a reliable source, use the following instructions:

  • On the Message Bar, click Enable Content.
    The file opens and is a trusted document.

The following image is an example of the Message Bar when macros are in the file.

Enable macros in the Backstage view.

Another method to enable macros in a file is via the Microsoft Office Backstage view, the view that appears after you click the File tab, when the yellow Message Bar appears.

  1. Click the File
  2. In the Security Warningarea, click Enable Content.
  3. UnderEnable All Content, click Always enable this document’s active content.
    The file becomes a trusted document.

The following image is an example of the Enable Content options.

Enable macros for one time when the Security Warning appears

Use the following instructions to enable macros for the duration that the file is open. When you close the file, and then reopen it, the warning appears again.

  1. Click the File
  2. In the Security Warningarea, click Enable Content.
  3. Select Advanced Options.
  4. In the Microsoft Office Security Optionsdialog box, click Enable content for this session for each macro.
  5. Click OK.

Change macro settings in the Trust Center

Macro settings are located in the Trust Center. However, if you work in an organization, the system administrator might have changed the default settings to prevent anyone from changing settings.

Important: When you change your macro settings in the Trust Center, they are changed only for the Office program that you are currently using. The macro settings are not changed for all your Office programs.

  1. Click the File
  2. Click Options.
  3. Click Trust Center, and then click Trust Center Settings.
  4. In the Trust Center, click Macro Settings.
  5. Make the selections that you want.
  6. Click OK.

The following image is the Macro Settings area of the Trust Center.

How to disable macros in office 2016