Modify the list of trusted publishers for macros - Access

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

Modify the list of trusted publishers for macros

Applies to: Microsoft Office Access 2003

Security Because macros can contain viruses, be careful about running them. Take the following precautions: run up-to-date antivirus software on your computer; set your macro security level to high; clear the Trust all installed add-ins and templates check box; use digital signatures; maintain a list of trusted publishers.

To perform some of these procedures, you must have Microsoft Internet Explorer 5.01 with Service Pack 2 (SP2) or later installed on your computer. To change security settings for macros (macro: An action or a set of actions you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.) or to clear the Trust all installed add-ins and templates check box, first do the following:

On the Tools menu, point to Macro and then click Security.

Show I can't see the Macro menu item on the Tools menu

If you do not see the Macro menu item on the Tools menu, click the arrows at the bottom of a drop-down menu to display the hidden menu items.

Tip If you want to see all menu items by default, on the Tools menu, click Customize, click the Options tab, and select the Always show full menus check box.

Show I can't see the Security command on the Macro menu

On the Tools menu, click Customize, and then click the Commands tab.
Click Rearrange Commands, select Menu Bar, and in the Menu Bar box, click Tools | Macro.
In the Controls section, click Add.
The Add command dialog box will appear.
In the Categories box, click Tools, and then in the Commands box, click Security.
The Security command will appear in the Controls box.
Use the Move Up and Move Down buttons to position the Security command where you want.
If you'd like to position the Security command in its own group (between horizontal lines), with Security selected, click Modify Selection and click Begin a Group. Select the menu item below the Security command, and repeat.
Click Close twice.

Now, do one of the following:

Show Add a macro developer to the list of trusted publishers

If you haven't already done so, set the macro security level to Medium or High.

How?
1. On the Tools menu, point to Macro, and then click Security.
2. Click the Security Level tab, and then select the security level you want to use.
Open the file or load the add-in (add-in: A supplemental program that adds custom commands or custom features to Microsoft Office.) that contains macros certified by the macro developer that you want to add to the list.
In the Security Warning box, select the Always trust macros from this publisher check box.

Note If the Security Warning box does not display the Always trust macros from this publisher check box, the macros are not digitally signed (digital signature: An electronic, encryption-based, secure stamp of authentication on a macro or document. This signature confirms that the macro or document originated from the signer and has not been altered.). You cannot add this macro developer to the list of trusted sources without a digital signature.

Show Remove a macro developer from the list of trusted publishers

On the Tools menu, point to Macro, and then click Security.
Click the Trusted Publishers tab.
Click the source you want to remove from the list.
Click Remove.