XL: "Cannot Open Add-In" Error When You Run a Macro

• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel 97 for Windows

SYMPTOMS

When you run a Visual Basic for Applications macro in Microsoft Excel 7.0 or Microsoft Excel 97, you may receive one of the following error messages:

   Run-time error '1004':
   Cannot open Microsoft Excel Add-In for editing. Please edit the source
   document instead.

   -or-

   Run-time error '1004':
   Cannot open Microsoft Excel 97 Add-In for editing. Please edit the
   source document instead.

CAUSE

This problem occurs if the following conditions are true:

• The macro you are running opens a Microsoft Excel add-in file (a .xla file).

  -and-

• You run the macro using a shortcut key that includes the SHIFT key. For example, you press the following keystroke:

        CTRL+SHIFT+T
  

WORKAROUND

To work around this problem, do not assign a shortcut key that includes the SHIFT key to any macro that opens any type of file.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

When you create a Visual Basic macro in Microsoft Excel, you can assign a shortcut key to the macro. When you press the shortcut key, Microsoft Excel runs the macro to which you assigned the shortcut key. To assign a shortcut key to a macro, use the following appropriate steps.

Microsoft Excel 97

1. On the Tools menu, point to Macro, and click Macros.

2. In the list of macros, click the macro to which you want to assign a shortcut key. Then, click Options.

3. Type a single letter in the shortcut key box.

4. Click OK. Then, click Cancel.

Microsoft Excel 7.0

1. On the Tools menu, click Macro.

2. In the list of macros, click the macro to which you want to assign a shortcut key. Then, click Options.

3. Select (check) the Shortcut Key check box. Then, type a single letter in the shortcut key box.

4. Click OK. Then, click Close.