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

• Microsoft Excel 2000

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 this to be a problem in the Microsoft products 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 : kberrmsg kbdta KbVBA
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug