Microsoft KB Archive/32511

{| = Using a Command Macro with Caps Lock =
 * width="100%"|

Last reviewed: November 29, 1994

Article ID: Q32511 The information in this article applies to:
 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
 * Microsoft Excel for OS/2, versions 2.2, 2.21, 3.0

SUMMARY
If CAPS LOCK is enabled when you enter the CTRL+ key sequence (where is the keycode) for a command macro in the Formula Define Name dialog box, a capital letter will be entered for the key. As a result, when the command macro is executed using CTRL+, the SHIFT key must be depressed, even if CAPS LOCK is enabled. Microsoft Excel ignores the status of CAPS LOCK when a CTRL key is used to begin a command macro.