I've selected a shortcut key for a macro in the menu bar:
Tools | Macros | Macro {macroname} Options

The preset text is Ctrl + Shift, and I've input an R in the textbox.

However, when I press Ctrl + Shift + R in Excel, the macro is not invoked.

Is there something that I'm missing?

Is there an alternate method of identifying a shortcut key?

The only reason I can think of why this doesn't work is if you already have
a macro assigned to this key combination. This could have been done using
Tools, Macro, Macros as you did, or by using a macro to assign an action
(Application.OnKey).

--
Jim Rech
Excel MVP
"ameliacat" wrote in message
...
I've selected a shortcut key for a macro in the menu bar:
Tools | Macros | Macro {macroname} Options

The preset text is Ctrl + Shift, and I've input an R in the textbox.

However, when I press Ctrl + Shift + R in Excel, the macro is not invoked.

Is there something that I'm missing?

Is there an alternate method of identifying a shortcut key?