list of used shortcut keys

[Smallweed]

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

 

[Gary''s Student]

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

 

[Peter T]

Try Ivan Moala's addin

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

Regards,
Peter T