Note An encrypted file is a file that you protect by using any of the following methods:
- Password protection
- Information Rights Management (IRM)
- Workbook protection in Microsoft Office Excel 2007
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 work around this issue, disable antivirus scanning on encrypted files that contain macros. To do this, follow these steps:
- Exit the 2007 Office programs.
- Click Start, click Run, type regedit, and then click OK.
- Locate and then click one of the following registry subkeys as appropriate:
- On the Edit menu, point to New, and then click DWORD Value.
- Type one of the following value names depending on the registry subkey that you clicked in step 3, and then press ENTER:
- Right-click the DWORD value that you created in step 4, and then click Modify.
- In the Value data box, type 1, and then click OK.
- On the File menu, click Exit to exit Registry Editor.
Article ID: 927150 - Last Review: Sep 18, 2011 - Revision: 1