Microsoft KB Archive/30532

Command Key for Excel Command Macro Not Working PSS ID Number: Q30532 Article last modified on 03-22-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00 | 2.20 2.21 3.00

WINDOWS | OS/2

Summary:

If a command macro was defined to have a control key, but pressing CTRL+letter (where letter is the assigned letter for the macro) will not execute the macro, check to see if the macro has an uppercase control key.

More Information:

To check this, choose Run from the Macro menu. The name of the macro should be listed. If the letter in front of the macro is a capital, press CTRL+SHIFT+letter to execute the macro or change the letter to its lowercase counterpart.

Changing the Control Key to Lowercase

 * 1) Activate the macro sheet containing the macro in question.
 * 2) From the Formula menu, choose Define Name.
 * 3) Select the macro name, which should be listed in the Names In Sheet list box.
 * 4) The control key for the macro will appear in the bottom right of the Define Name dialog box.
 * 5) Change the letter to a lowercase letter.
 * 6) Choose OK.

Reference(s):

“Microsoft Excel User’s Guide,” version 3.0, pages 580, 599

Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00 3.0

Copyright Microsoft Corporation 1993.