| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Changing shortcut keys on macros
Hi: I have a bunch of macros that have old ctl+ shortcut keys that need to
be changed and/or deleted. But I can't find a clue in the VBA code. any ideas? wayne |
|
#2
|
|||
|
|||
|
I don't know about a VBA method, but you can change/delete the shortcut key
in a macro by going to Tools|Macro|Macros|Options Ian "WayneB" wrote in message ... Hi: I have a bunch of macros that have old ctl+ shortcut keys that need to be changed and/or deleted. But I can't find a clue in the VBA code. any ideas? wayne |
|
#3
|
|||
|
|||
|
Take a look at application.macrooptoins in VBA's help:
Application.MacroOptions Macro:="myMacro", _ HasShortcutKey:=True, ShortcutKey:="U" WayneB wrote: Hi: I have a bunch of macros that have old ctl+ shortcut keys that need to be changed and/or deleted. But I can't find a clue in the VBA code. any ideas? wayne -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the shortcut key for Help (F1)? | Excel Discussion (Misc queries) | |||
| how to display shortcut keys for icons on toolbars | Excel Discussion (Misc queries) | |||
| Creating shortcut keys | Excel Discussion (Misc queries) | |||
| Macro Shortcut Keys | Excel Discussion (Misc queries) | |||
| How to make [toggling] shortcut keys to superscript and subscript, respectively? | Excel Discussion (Misc queries) | |||
Hybrid Mode
