Getting Shortcut Information ?
 

Using VBA I can assign a shortcut to a macro as follows:
Sub set_shortcut()
Application.MacroOptions Macro:="zt", HasShortcutKey:=True, ShortcutKey:="e"
End Sub

Help in VBA was valuable in setting the Options, but had no advice on
reading them back !

How to go backwards? I would like a function to return the shortcut key
given the macro name, for example

seeshort("zt") would return e

Thanks in advance for your help
--
jake

Getting Shortcut Information ?
 

Macro Shortcuts are stored as hidden attributes of the macro. AFAIK can only
be found by exporting the module and finding the particular attribute in the
text file or view in a text editor.

Try Ivan Moala's addin
http://www.xcelfiles.com/GetShortCutKeys.html

Regards,
Peter T

"Jakobshavn Isbrae" wrote in
message ...
Using VBA I can assign a shortcut to a macro as follows:
Sub set_shortcut()
Application.MacroOptions Macro:="zt", HasShortcutKey:=True,
ShortcutKey:="e"
End Sub

Help in VBA was valuable in setting the Options, but had no advice on
reading them back !

How to go backwards? I would like a function to return the shortcut key
given the macro name, for example

seeshort("zt") would return e

Thanks in advance for your help
--
jake

Getting Shortcut Information ?
 

Thank you Peter!!!


The export thing is just what I need. All the assigned shortcuts are
displayed in the .bas file.
--
jake


"Peter T" wrote:

Macro Shortcuts are stored as hidden attributes of the macro. AFAIK can only
be found by exporting the module and finding the particular attribute in the
text file or view in a text editor.

Try Ivan Moala's addin
http://www.xcelfiles.com/GetShortCutKeys.html

Regards,
Peter T

"Jakobshavn Isbrae" wrote in
message ...
Using VBA I can assign a shortcut to a macro as follows:
Sub set_shortcut()
Application.MacroOptions Macro:="zt", HasShortcutKey:=True,
ShortcutKey:="e"
End Sub

Help in VBA was valuable in setting the Options, but had no advice on
reading them back !

How to go backwards? I would like a function to return the shortcut key
given the macro name, for example

seeshort("zt") would return e

Thanks in advance for your help
--
jake