Macro Shortcut Key Assignments Excel 2010

darchambault1

New Member
Joined
Aug 10, 2015
Messages
2
I have several, probably more than 10 shortcut keys assigned to my macros. I know I can open each macro and check options to see which key I have assigned, but is there a property in VBE that will tell me which, if any, shortcut key I assigned to a macro? Or is there any handy code that someone has available to help me more easily identify which keys I have assigned already?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,389
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
If you assigned the shortcut keys using the macros dialog, you can only export the module and read through it to find the shortcut keys. They aren't exposed through any property in VBA.
 

Forum statistics

Threads
1,082,601
Messages
5,366,571
Members
400,902
Latest member
fathima

Some videos you may like

This Week's Hot Topics

Top