Ostatní 25. 6. 2010 CZ

A macro that is contained in an encrypted Office Open XML file does not run in 2007 Office programs

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...

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:

  • Password protection
  • 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:

  1. Exit the 2007 Office programs.
  2. Click Start, click Run, type regedit, and then click OK
  3. Locate and then click one of the following registry subkeys as appropriate:
    1. HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security
    2. HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\PowerPoint\Security
    3. HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\Security
  4. On the Edit menu, point to New, and then click DWORD Value.
  5. Type one of the following value names depending on the registry subkey that you clicked in step 3, and then press ENTER:
    1. ExcelBypassEncryptedMacroScan
    2. PowerPointBypassEncryptedMacroScan
    3. WordBypassEncryptedMacroScan
  6. Right-click the DWORD value that you created in step 4, and then click Modify.
  7. In the Value data box, type 1, and then click OK.
  8. On the File menu, click Exit to exit Registry Editor.