When you try to run a macro in an encrypted workbook in Microsoft Office Excel 2007, the macro does not run. Additionally, you receive the following message: To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:
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
Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in WindowsWarning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
For more information about encrypted files and the scanning of encrypted content in the 2007 Microsoft Office programs, click the following article number to view the article in the Microsoft Knowledge Base:
927150 A macro that is contained in an encrypted Office Open XML file does not run in 2007 Office programsTo 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 the registry subkeys provided below:
- On the Edit menu, point to New , and then click DWORD Value .
- Type the following value name 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.