Thread: Shortcut Key
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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?