Windows 7: Excel Macros Disabled Under W7

Add a trusted publisher via the Trust Center If you know that active content (macros, ActiveX controls, data connections, and so on) from a new publisher is reliable, you can add the publisher to the trusted publishers list in the Trust Center.

1. Open the file from the new publisher.
2. Click the File tab. The Backstage view appears.
3. Under Help, click Options; the Options dialog box appears.
4. Click Trust Center.
5. Click Trust Center Settings; the Trust Center appears.
6. Click Trusted Publishers.
7. From the list, select the publisher's certificate, and then click OK.

The following image is an example of the Trusted Publishers area of the Trust Center.

Important If you open a file from a publisher and you receive a warning message that there is no signature present, or that the signature is invalid, you should not enable the content or trust the publisher unless you are sure the code project comes from a reliable source. You can learn more about digital signatures and their certificates in How to tell if a digital signature is trustworthy.
Top of Page
View or remove a trusted publisher

1. Open a file created by a publisher
2. Click the File tab. The Backstage view appears.
3. Under Help, click Options; the Options dialog appears.
4. Click Trust Center.
5. Click Trust Center Settings; the Trust Center appears.
6. Click Trusted Publishers.
7. In the Trusted Publishers list, select the publisher to remove. Click Remove.
8. Click OK.