List active onkey assignments?

[SysMod]

Is there a way to list the hotkeys and the names of the procedures assigned
to them currently in an instance of Excel, whatever their origin?
TIA
Patrick

 

[Bob Phillips]

I have never been able to find a way to do this, although it would be so
useful.

 

[Mike H]

Hi,

Not tested but have a look here

http://www.xcelfiles.com/GetShortCutKeys.html

Mike

 

[SysMod]

Thanks, Mike,
That's Ivan F Moala's addin.
So there's no easier way than exporting the codemodule and scanning its text.
If only MS would make Application.OnKey a function that returned the present
setting, that would be handy.

Regards
Patrick

 

[Bob Phillips]

That only gets keys assigned to macros via that method, it doesn't get all
keys assigned via OnKey in code, which is where I say I don't think it is
possible.