There are a few ways to set a shortcut for a macro. The easiest one is through the menu Developer> Macros > Options, select the macro and write the shortcut:
However, there is a better way to do this – with a code :
It is better, because with the code you can enable and disable the shortcut whenever you like. This is how the code looks like:
|
1 2 3 4 5 6 7 |
Sub GenerateShortCut() Application.OnKey "^c", "TestMe" End Sub Sub RemoveShortCut() Application.OnKey "^c", "" End Sub |
The first sub Generates a shortcut to the procedure “TestMe” with Ctrl+C. The second sub removes this shortcut. How do we know that the “^” sign stands for Ctrl? Well, we simply use google or the table below:
| Shortcut | Sign | |
|---|---|---|
| Shift | + | |
| Control | ^ | |
| Alt | % | |
| F1 to F15 | {F1} to {F15} | |
| Left Arrow | {Left} | |
| Up Arrow | {Up} | |
| Escape | {Escape} |
Enjoy it 🙂