Microsoft KB Archive/928613

= You receive a message when you try to run a macro in an encrypted workbook in Excel 2007: &quot;Because of your security settings, macros have been disabled&quot; =

Article ID: 928613

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Excel 2007

-



SYMPTOMS
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:

Because of your security settings, macros have been disabled. To run macros, you need to reopen this workbook, and then choose to enable macros. For more information about enabling macros, click Help.

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:

101644



RESOLUTION
To resolve this issue, upgrade the antivirus program that is installed on the computer to a program that supports the scanning of encrypted content. Microsoft Antivirus API supports the scanning of encrypted content.



WORKAROUND
To work around this issue, do not save the workbook as an Excel Macro-Enabled Workbook (*.xlxm) file or as an Excel Binary Workbook (*.xlsb) file. Instead, save the original workbook as an Excel 97-2003 Workbook (*.xls) file.

To do this, follow these steps:
 * 1) Create the original encrypted Excel workbook in Excel 2007, but do not save the workbook.
 * 2) Click the Microsoft Office Button, and then click Save As.
 * 3) In the Save As dialog box, click Excel 97-2003 Workbook (*.xls) in the Save as type box.
 * 4) Name the file, and then click Save.

Note When you close and then reopen the encrypted workbook, the macro functions as expected.



MORE INFORMATION
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 programs

Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12 101644

Keywords: kberrmsg kbtshoot kbprb kbexpertisebeginner kbofficealertid KB928613

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.