Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
list of used shortcut keys
Does anyone know a way of listing the shortcut keys being used by macros in
the open workbook(s)? I have a long list of macros and don't particularly want to go manually through the Options on every single one to find what Ctrl-G is now doing... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
list of used shortcut keys
Export the modules and scan the .bas files. For example:
Sub dural() MsgBox (" ") End Sub If assigned CNTRL-e will produce a .bas file like: Sub dural() Attribute dural.VB_ProcData.VB_Invoke_Func = "e\n14" MsgBox (" ") End Sub -- Gary''s Student - gsnu200771 "Smallweed" wrote: Does anyone know a way of listing the shortcut keys being used by macros in the open workbook(s)? I have a long list of macros and don't particularly want to go manually through the Options on every single one to find what Ctrl-G is now doing... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
list of used shortcut keys
Try Ivan Moala's addin
http://www.xcelfiles.com/GetShortCutKeys.html Regards, Peter T "Smallweed" wrote in message ... Does anyone know a way of listing the shortcut keys being used by macros in the open workbook(s)? I have a long list of macros and don't particularly want to go manually through the Options on every single one to find what Ctrl-G is now doing... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List of Shortcut Keys | Excel Programming | |||
Macro Shortcut Key Conflicts with Application Shortcut Keys | Excel Programming | |||
Macro Shortcut Key Conflicts with Application Shortcut Keys | Excel Programming | |||
List of macro shortcut keys | Excel Programming | |||
How to make a list of all shortcut keys | Excel Programming |