#EXCEL ASSIGN HOTKEY TO MACRO HOW TO#

A couple of mins of Googling shows there are now new kb shortcuts in Excel and that I'll have to change the one I had assigned (Ctrl+Q). When I try to run one of my personal macros that has a keyboard shortcut it doesn't work. If you don't mind overriding that default, click the 'Assign' button on the lower-left to assign 'Ctrl+f: to run your 'fred' macro.Д«y default the assignment is saved in the Normal.dotm document template. Have recently upgraded computer, OS and Excel versions (Win10, Excel 365 (1902)).In this case it shows 'Currently assigned to NavPaneSearch'. Click the 'Press new shortcut key' textbox to make it active.The Macros list box should now show the list of custom macros.In the Macro name box, insert a name for the macro (no spaces are allowed between characters). Select (Tools > Macro > Macros) to display the Macro dialog. From the Tools menu, select Macro, and then Record New Macro. Alternatively, you can use the keyboard shortcut Alt + F8. In the Categories listbox scroll down to the buttom and select Macros. You could run your macro by using a shortcut key. We can use the Macro Options window in Excel to create a shortcut key to call the macro.

Click 'Keyboard shortcuts: Customize' button.

Click on Customize Ribbon (from my perspective this is the non-intuitive step).

The scenario is you created a macro named 'fred' and you want to execute the macro by typing Ctrl+f.

#EXCEL ASSIGN HOTKEY TO MACRO HOW TO#

Here is how to assign a keyboard shortcut to a custom macro in Word 2013.

Excel assign hotkey to macro