Microsoft KB Archive/826714

= Error Messages When You Open an Excel 2003 Workbook =

Article ID: 826714

Article Last Modified on 7/27/2006

-

APPLIES TO


 * Microsoft Office Excel 2003

-





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.



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.



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.
 * 1) Repeat step 2 for each name that is defined for the workbook.
 * 2) Click OK.
 * 3) On the File menu, click Save as, and then save the workbook under a different name.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section of this article.

Additional query words: XL11 XL2003 XL4 VBA

Keywords: kbformula kbmacro kbfix kberrmsg kbbug KB826714

-

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

© Microsoft Corporation. All rights reserved.