Start by going to the Developer tab and clicking on the Macros button. Here are the instructions on how to set it up. 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)
