MrExcel ® is a registered trademark of Tickling Keys, Inc.Īll contents © 1998 - 2022 MrExcel Publishing | All rights reserved.Assigning Shortcut Key For Macro Execution Dec 18, 2012 View our Privacy Policy, Cookies Policy, and Terms of Use.Įxcel ® is a registered trademark of the Microsoft Corporation. You can earn a commission for sales leads that you send to us by joining our Any affiliate commissions that weĮarn when you click a link to Amazon or other sites is reinvested in keeping Web site are provided 'as is' and we do not guarantee that they can be used in all The Formulas, Functions and Visual Basic procedures on this provides examples of Formulas, Functions and Visual Basic proceduresįor illustration only, without warranty either expressed or implied, includingīut not limited to the implied warranties of merchantability and/or fitness forĪ particular purpose. This article is an excerpt from Excel Gurus Gone Wild. Source: Need help creating shortcut keys to add-in macros on the MrExcel Message Board. Summary: There are several ways to assign the shortcut key associated with a macro. You can export the module to see all the shortcut keys used. The G 14 attribute means the macro is assigned to Ctrl+Shift+G.įigure 105. So, in Figure 105, the g 14 attribute means the macro is assigned to Ctrl+g. The shortcut key is listed, followed by /n14.

You see an attribute near each module.

Excel proposes a name such as Module1.bas.

Save the file in a place where you can find it later.

Right-click the module in the Project Explorer and choose Export File.

To permanently change the shortcut key via code, use:Īdditional Details: Excel stores the shortcut key in the code module, but it is not visible in the Visual Basic editor. To cancel this assignment and return Ctrl+m to its normal function, use:

The following line of code temporarily assigns the MoveDown procedure to Ctrl+m: Perhaps you want to turn on a shortcut key during one section of a process and turn it off later in the process.

Figure 104.Y ou can change the shortcut key using this dialog.Īdditional Details: You can temporarily assign a macro to a shortcut key by using a macro.

You can edit the shortcut key here ( Figure 104). Click the macro in question and click the Options button in the Macro Options dialog. Solution: To change the shortcut key, press the F8 key to see a list of macros. However, changing the comment in the macro does not have any effect on the actual shortcut key used. Excel documents the shortcut key used when recording a macro in the comments at the top of the macro. Now you need to change the shortcut key used for the macro. Challenge: You recorded a macro but forgot to assign it to a shortcut key.

View macro shortcut keys