Getting Shortcut Information ?

  • Thread starter Jakobshavn Isbrae
  • Start date
J

Jakobshavn Isbrae

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
 
J

Jakobshavn Isbrae

Thank you Peter!!!


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top