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

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

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