Microsoft KB Archive/200132

= OFF2000: Macro Virus Warning When Inserting MS Excel Workbook =

Article ID: 200132

Article Last Modified on 11/13/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Word 2000 Standard Edition
 * Microsoft Office Binder 2000

-



This article was previously published under Q200132





SYMPTOMS
When you insert a Microsoft Excel workbook into a document in Microsoft Word 2000 or in a binder in Microsoft Office Binder 2000, you may receive the following message:

Microsoft Excel The workbook you are opening contains macros. Some macros may contain harmful viruses. If you are sure this workbook is from a trusted source, click Yes. If you are not sure and want to prevent any macros from running, click No.

Note that you receive the same message twice.

You may also receive the message once when you perform either of the following actions:


 * You switch to an Excel workbook that is embedded in a Word document.

-or-
 * You open a binder that contains an Excel workbook.



CAUSE
This problem occurs if any of the following conditions are true:
 * You insert an Excel workbook that contains macros into either a Word document or an Office binder.

-or-
 * In Word, you switch to an embedded workbook that contains macros.

-or-
 * You open a binder that contains a workbook that contains macros.



WORKAROUND
To work around this problem, use either of the following methods:  Remove all the macros from the workbook before you insert it into a Word document or a binder.

-or- Disable macro virus protection in Excel. To do this, follow these steps:

 On the Tools menu, point to Macro and click Security. On the Security Level table, click Low. Click OK.

NOTE: If you do this, you are not warned when you open a workbook that contains macros. This makes it possible for Microsoft Excel workbooks to become infected with macro viruses if you open a workbook that contains one. Use this option with caution.</li></ul>

<div class="moreinformation_section">

MORE INFORMATION
The programs included with Office that support the use of Visual Basic for Applications macros also include macro virus protection. If this feature is selected, you receive a warning message whenever you open a file (such as a workbook or a document) that contains macros.

In some cases, you may receive a macro virus warning message twice when you open a file by using any of the following methods:


 * You open the file in the program that created it.
 * You insert the file into a document in another program.
 * You insert the file into a binder by clicking Add From File on the Section menu.

This behavior occurs as a result of how the file is opened or inserted by the program you are currently using.

Additional query words: OFF2000 XL2000

Keywords: kbbug kbnofix KB200132

-

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

© Microsoft Corporation. All rights reserved.