Article ID: 175223
Article Last Modified on 10/22/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q175223
SYMPTOMS
In Microsoft Excel, when you run a Visual Basic for Applications Sub procedure that opens a workbook, the procedure may halt before all the code in the Sub procedure is executed.
NOTE: When the Sub procedure halts, Microsoft Excel is in "design mode." All code in the macro before the code that opens the workbook is executed.
CAUSE
This behavior occurs when the following conditions are true:
- You assign a shortcut key to the macro. -and-
- You press the shortcut key to run the macro. -and-
- The SHIFT key is part of the shortcut key (for example, CTRL+SHIFT+A). -and-
- The macro code opens a workbook by using the Open method (for example, Workbooks.Open).
RESOLUTION
To resolve this problem, remove SHIFT from the macro shortcut key combination when the code includes Workbooks.Open. To change the shortcut key for a macro, follow these steps:
- Start Microsoft Excel and open the workbook that contains the macro.
- Point to Macro on the Tools menu, and then click Macros.
- Click the macro name in the list and click Options.
- In the Shortcut Key box, type a letter without holding down SHIFT.
- Click OK, and then click Cancel.
STATUS
Microsoft has confirmed this to be a problem in the products listed above.
MORE INFORMATION
To assign a shortcut key to a macro, follow these steps:
- On the Tools menu, point to Macro, and then click Macros.
- In the Macro name box, enter the name of the macro you want to assign to a shortcut key.
- Click Options.
- To run the macro by pressing a shortcut key, type a letter in the Shortcut Key box.
You can use CTRL+<letter> or CTRL+SHIFT+<letter> where <letter> is any letter key on the keyboard. The shortcut key overrides any default Microsoft Excel shortcut key assignments while the workbook that contains the macro is open.
- Click OK, and then click Cancel.
Additional query words: XL97
Keywords: kbbug KB175223