List active onkey assignments?

  • Thread starter Thread starter SysMod
  • Start date Start date
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
 
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
 
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.
 
Back
Top