You receive an error message when you open a workbook that contains XLM macros in Excel 2003

When you try to open a workbook, you receive the following error message: The workbook does not open.

This problem occurs when the following conditions are true:

• Your workbook contains Excel 4.0 (XLM) macros.
  
  -and-
  
• The macro security level of Excel has been set to High.

To resolve this issue, you must add a key to the registry that allows Excel to run XLM macros when the macro security level is set to High. To do this, follow these steps:

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

1. Click Start, and then click Run.
2. In the Run box, type regedit, and then click OK.
3. In Registry Editor, locate and expand the following registry subkey:
   HKEY_LOCAL_MACHINE\Software\Microsoft\Office\11.0\Excel
4. On the Edit menu, point to New, and then click Key.
5. Type Security, and then press ENTER.
6. On the Edit menu, point to New, and then click DWORD Value.
7. Type XLM, and then press ENTER.
8. Double-click XLM.
9. In the Edit DWORD Value dialog box, type 1 in the Value data box, and then click OK.
10. On the File menu, click Exit.

After you add the XLM key to the registry, you cannot disable XLM macros. This section of this article describes the behavior of Excel after you add the XLM key to the registry.

The Workbook Contains XLM Code

When you open a workbook that contains XLM macro code, you are prompted with the following message: If you click Enable Macros, the workbook opens and the XLM macros are available to run. If you click Disable Macros, you receive the following message: If you click Yes, the workbook opens. The XLM macros are available to run. If you click No, the workbook does not open.

The Workbook Contains XLM Code and Visual Basic for Applications Code

When you open a workbook that contains both XLM code and Visual Basic code, you may receive the following message: If you click Yes, the workbook opens. The XLM macros are available to run. If you click No, the workbook does not open. Visual Basic macros are not enabled.