List active onkey assignments?

S

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
 
B

Bob Phillips

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

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
 
B

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.
 
Top