shortcut keys in macro

[InnaG]

Hello,
Is there a way to create a list of all the shortcut keys I am already using in my personal xls file?
Basically, I need a list off all my macros and their shortcut keys.
Thanks,

 

[Fluff]

It's possible but not easy, have a look here https://excel.tips.net/T003162_List_of_Macro_Shortcuts_in_All_Open_Workbooks.html

 

[InnaG]

Yes, I tried but could not open this page:http://www.xcelfiles.com/GetShortCutKeys.html

 

[Fluff]

It seems that Ivan's site is working properly.
Butt looks like the code is available here
https://groups.google.com/forum/?hl...ic.excel.programming/9Mnmt6sE-EA/R6vFjhYSBGQJ

 

[InnaG]

Thanks, got it

 

[Fluff]

You're welcome & thanks for the feedback