XL2000: Cannot Open Add-In Error When Running a Macro (213527)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q213527

SYMPTOMS

When you run a Visual Basic for Applications macro in Microsoft Excel, you may receive the following error message:
Run-time error '1004': Cannot open Microsoft Excel Add-In for editing. Please edit the source document instead.

CAUSE

This problem occurs when you run a macro that opens an add-in (*.xla) file, and you run the macro by pressing a shortcut key combination that includes the SHIFT key. For example, you press the following keystroke:

CTRL+SHIFT+T

WORKAROUND

To work around this problem, only assign shortcut key combinations that do not include the SHIFT key to run macros that open any type of file.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

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, follow these steps:
  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 and then click Options.
  3. Type a single letter in the Shortcut key box.
  4. Click OK. Click Cancel.
Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbbug kberrmsg kbpending KB213527
©2004 Microsoft Corporation. All rights reserved.