Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
A macro that is contained in an encrypted Office Open XML file does not run in 2007 Office programs
Article ID: 927150 - View products that this article applies to.
In one of the 2007 Microsoft Office programs that are listed in the "Applies to" section, when you try to run a macro that is contained in an encrypted Office Open XML file, such as an .xlsm file, a .docm file, or a .pptxm file, the macro does not run as expected. This behavior does not occur for files that are saved in the "Microsoft Office 97 - 2003" file format.
Note An encrypted file is a file that you protect by using any of the following methods:
This behavior occurs if the computer is not running an active antivirus program that supports the scanning of encrypted content as supported by the Microsoft Antivirus API. In this case, macros are disabled in encrypted Office Open XML files.
Also, macros may be disabled in the file by the security settings in the program. If macros are disabled by the security settings, you receive the following error message when you try to open the file: .
To enable the macros, click Options , click Enable this content, and then click OK. However, if you enable the macros, the behavior that is mentioned in the "Symptoms" section still occurs.
Security Alert This file contains encrypted macros that have been disabled because there is no antivirus software installed that can scan them. To run these macros, remove the encryption or permission restrictions on this file. File Path: <path and name of file> Help protect me from unknown content (recommended) <More information> Prevent encrypted macros from being scanned for viruses.
The 2007 Office release provides several settings that enable you to prevent encrypted macros from being scanned for viruses. This is useful if your virus-scanning program does not support the Microsoft Antivirus application programming interface (API).
By default, macros are encrypted when you encrypt and save a file in the Office Open XML file formats. If your virus-scanning program does not support the Microsoft Antivirus API, your virus-scanning program cannot scan encrypted macros. Therefore, encrypted macros will be disabled.
To resolve this behavior, install 'The 2007 Microsoft Office Suite Service Pack 2 (SP2) which can be downloaded from the Microsoft Download Center at http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b444bf18-79ea-46c6-8a81-9db49b4ab6e5
Warning This workaround may make a computer or a network more vulnerable to attack by malicious users or by malicious software such as viruses. We do not recommend this workaround but are providing this information so that you can implement this workaround at your own discretion. Use this workaround at your own risk.
To work around this issue, disable antivirus scanning on encrypted files that contain macros. To do this, follow these steps:
Note The steps above should not be used after Office 2007 SP2 has been installed. This registry information is also provided in the '2007 Microsoft Office Security Guide', but that documentation was created prior to the release of the Office 2007 Service Pack 2.