Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

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: https://www.excelcampus.com/vba/keyboard-shortcut-run-macro/

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 video to find out. :-)

Please leave a comment below with any questions or suggestions.

Related videos & posts:

How to Create Your Personal Macro Workbook: https://youtu.be/rD2-mSbTuL0

How to Run Event Macros based on User Actions:
https://youtu.be/VJWBOuNXHB4

Add Macro Buttons to the Ribbon Toolbar: https://youtu.be/dmdolFcS-fI

How to Enable the Developer Tab:
https://youtu.be/JLQ8OuW0FlY

Best keyboards for Excel Shortcuts: https://www.excelcampus.com/keyboard-shortcuts/best-keyboards-for-excel-keyboard-shortcuts/

18 Excel Shortcuts for 2018:
https://www.excelcampus.com/vba/excel-vba-macro-shortcuts/
00:00 Introduction
00:40 Macro Options Window
02:51 Macro Options Window Pros and Cons
04:45 Onkey Method
09:55 Pros and Cons
12:51 Conclusion