Microsoft KB Archive/213527

= XL2000: Cannot Open Add-In Error When Running a Macro =

Article ID: 213527

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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.

Additional query words: XL97 XL7 XL2000

Keywords: kbbug kberrmsg kbpending KB213527

-

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

© Microsoft Corporation. All rights reserved.