Help and Support
 

powered byLive Search

OFF2000: Macro Virus Warning When Inserting MS Excel Workbook

Article ID:200132
Last Review:November 13, 2003
Revision:3.0
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.

Back to the top

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.

Back to the top

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:

a. On the Tools menu, point to Macro and click Security.
b. 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.

Back to the top

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.

Back to the top


APPLIES TO
Microsoft Excel 2000 Standard Edition
Microsoft Word 2000 Standard Edition
Microsoft Office Binder 2000

Back to the top

Keywords: 
kbbug kbnofix KB200132

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.