Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Error Messages When You Open an Excel 2003 Workbook


View products that this article applies to.

Symptoms

When you open a workbook in Microsoft Office Excel 2003, you receive one of the following error messages:
This workbook contains one or more Microsoft Excel 4.0 macros. These macros may contain viruses or other harmful code. These macros will be disabled.
-or-
This workbook contains one or more Microsoft Excel 4.0 macros. These macros may contain viruses or other harmful code. Open this workbook only if you trust the source. Do you want to enable these macros?
Note You receive the first error message if the Macro Security setting is set to High or Very High. You receive the second error message if the setting is set to Medium. You do not receive an error message if the Macro Security setting is set to Low, and the XLM macros in the defined names will run.

↑ Back to the top


Cause

This problem occurs if the workbook contains one or more defined names that are assigned to Microsoft Excel 4.0 macro commands, such as Get.Document() and Excel's Macro Security setting is set to Medium or High.

↑ Back to the top


Workaround

To work around this problem,, you can remove the defined name or names from the workbook. To do so, follow these steps:
  1. On the Insert menu, point to Name, and then click Define.
  2. Select a name and look to see if the name is assigned to a spreadsheet range or constant.

    If the name is not assigned to a range or constant, make note of what the name is assigned to, and then click Delete.
  3. Repeat step 2 for each name that is defined for the workbook.
  4. Click OK.
  5. On the File menu, click Save as, and then save the workbook under a different name.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section of this article.

↑ Back to the top


Keywords: KB826714, kbbug, kberrmsg, kbfix, kbmacro, kbformula

↑ Back to the top

Article Info
Article ID : 826714
Revision : 5
Created on : 7/27/2006
Published on : 7/27/2006
Exists online : False
Views : 249