Keyboard shortcut to macro ribbon in Excel
To do it in Excel, here is the answer:
a) Click on "Macros" under "Developer".
b) In the "Macro" Dialog box that comes up, click on the macro of interest and then click on "Options".
c) Enter a suitable easy to remember character for Shortcut Key. Click OK. Shortcut Key for the macro of interest is now set as "Ctrl+q". To run the macro, simply press "Ctrl+q".
Caution: Shortcut keys assigned to macros take precedence over built in shortcut keys like ctrl+c, ctrl+v, ctrl+s. So, assign shortcut keys carefully to macros.