Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA SharePoint List Field Type assignments | Excel Programming | |||
key assignments | Excel Programming | |||
Keyboard key assignments change... | Excel Programming | |||
List Shortcut Assignments | Excel Programming | |||
How can I see a list of macro key assignments in Excel 2002? | Excel Worksheet Functions |