![]() ![]() ![]() The G\n14 attribute means the macro is assigned to Ctrl Shift G.įigure 105. So, in Figure 105, the g\n14 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. Excel macro shortcut keys list code#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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |