List active onkey assignments?
 

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

List active onkey assignments?
 

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

--
__________________________________
HTH

Bob

"SysMod" wrote in message
...
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

List active onkey assignments?
 

Hi,

Not tested but have a look here

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

Mike

"SysMod" wrote:

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

List active onkey assignments?
 

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

List active onkey assignments?
 

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.

--
__________________________________
HTH

Bob

"Mike H" wrote in message
...
Hi,

Not tested but have a look here

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

Mike

"SysMod" wrote:

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