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?
|