Error Messages When You Open an Excel 2003 Workbook

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.
  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.

Status

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

ID do Artigo: 826714 - Última Revisão: 20 de jun de 2014 - Revisão: 1

Comentários