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.
An encrypted file is a file that you protect by using any of the following methods:
- Information Rights Management (IRM)
- Workbook protection in Microsoft Office Excel 2007
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
or another method is:
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:
- HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security
- HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\PowerPoint\Security
- HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\Security
- 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:
- ExcelBypassEncryptedMacroScan
- PowerPointBypassEncryptedMacroScan
- WordBypassEncryptedMacroScan
- 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.