After selecting the macro that you want to assign the shortcut to, click the Options button.(If you don't see the Developer tab on your ribbon, you can add it using these instructions.) Alternatively, you can use the keyboard shortcut Alt+ F8.
We can use the Macro Options window in Excel to create a shortcut key to call the macro. I also explain the pros & cons of each method. These include the Macro Options window and VBA code for the Application.OnKey method. In this post we look at two popular ways to create the shortcut keys. This is especially true if you have to perform the same actions repeatedly. Assign-Keyboard-Shortcut-to-Macro.zip Download Create Your Own Keyboard Shortcuts to Run MacrosĪssigning keyboard shortcuts to simple or complex macros can help you work faster in Excel.
0 kommentar(er)
