Microsoft KB Archive/175223

From BetaArchive Wiki
Knowledge Base

Article ID: 175223

Article Last Modified on 10/22/2000


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q175223


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.


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).


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:

  1. Start Microsoft Excel and open the workbook that contains the macro.
  2. Point to Macro on the Tools menu, and then click Macros.
  3. Click the macro name in the list and click Options.
  4. In the Shortcut Key box, type a letter without holding down SHIFT.
  5. Click OK, and then click Cancel.


Microsoft has confirmed this to be a problem in the products listed above.


To assign a shortcut key to a macro, follow these steps:

  1. On the Tools menu, point to Macro, and then click Macros.
  2. In the Macro name box, enter the name of the macro you want to assign to a shortcut key.
  3. Click Options.
  4. 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.

  1. Click OK, and then click Cancel.

Additional query words: XL97

Keywords: kbbug KB175223