keyboard shortcut to macro ribbon in Excel

Q137. I frequently use a Macro - is there a way to quickly access / run the Macro using a Keyboard Shortcut?

To do it in Excel, here is the answer:

a) Click on "Macros" under "Developer".

excel keyboard shortcut to macro ribbon

b) In the "Macro" Dialog box that comes up, click on the macro of interest and then click on "Options".

excel excel keyboard shortcut to macro ribbon

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.

excel excel excel keyboard shortcut to macro ribbon

 

You can find similar Excel Questions and Answer hereunder

1) How do I assign a macro to a shape using VBA?

2) Converting numbers stored as text to numbers via macro in Excel

3) Keyboard shortcut for save as in Excel

4) How can I make my macro wait for 5 secs before executing the next command?

5) I have a macro that takes a lot of time for execution - how can I keep the user informed that the macro is running?

6) How can I clear cell after activating a routine when there is a change in value of a cell?

7) I have a very complex macro that runs for a long time - is there any way I can set up an audible alarm indicating macro run is over?

8) How can I execute an event at a predetermined time from my Macro?

9) How can I add a Timestamp after macro execution?

10) I frequently use a Macro - is there a way to quickly access the Macro in the Excel Ribbon?

11) How can I avoid updates to cell values during macro execution?

12) I want to automatically run a procedure whenever I close my WorkBook so that it is in a known state - how can I achieve that?

13) How can I activate a routine when there is a change in value of a cell?

14) Calling a macro from another workbook in Excel

15) How can I prevent users from seeing / accessing my macro code?