| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| shortcut has change or move so this shortcut can not open | Excel Worksheet Functions | |||
| Pivot table cutting information of a part of the information | Excel Discussion (Misc queries) | |||
| Help!! using sheet 1 information to change information on sheet 2 | Excel Worksheet Functions | |||
| Macro Shortcut Key Conflicts with Application Shortcut Keys | Excel Programming | |||
| Macro Shortcut Key Conflicts with Application Shortcut Keys | Excel Programming | |||
Linear Mode
