How to make a keyboard shortcut?

Lea

Board Regular
Joined
Oct 1, 2007
Messages
119
I would like to make a keyboard shorcut for a macro that I have. I would like it to be Alt+g. Does anyoone know how I can do this? If I go to Tools, Macro, Macros, the Options button only gives me the option to do Ctrl+.
Thanks.
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,056
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
You can use Application.Onkey for this:
Code:
Sub SetKey()
   Application.OnKey "^g", "macro_name" '<---change macro name!
End Sub
Sub ResetKey()
   Application.OnKey "^g"
End Sub
You can use the Workbook_Open event to call the SetKey routine, and the Workbook_BeforeClose event to reset the key combination.
HTH
 

iliace

Well-known Member
Joined
Jan 15, 2008
Messages
3,543
Office Version
  1. 365
  2. 2016
  3. 2010
Platform
  1. Windows
This line of code will cause Alt+G to run myMacro:

Code:
  Application.OnKey "%g", "myMacro"

You can put that in your workbook_open or workbook_activate event. In the opposite event (workbook_close or workbook_deactivate) you can use this line to unbind the key combination:

Code:
  Application.OnKey "%g"
 

Watch MrExcel Video

Forum statistics

Threads
1,122,224
Messages
5,594,912
Members
413,952
Latest member
JGer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top