About this tutorial:
Video duration: 00:13:41
In this video I explain 2 ways to create keyboard shortcuts to run macros in Excel. Assigning shortcut keys to macros in your Personal Macro Workbook allows you to run the macros on any open file.
Download the sample Excel file here:
The first way is using the Macro Options window. This can be accessed from Excel, and is easy to setup.
The second way is using VBA code and the Application.OnKey method. This method requires a bit more setup work, but does have some distinct advantages.
Which method is better? Watch the…