Changing shortcut keys on macros

[WayneB]

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

 

[IC]

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

 

[Dave Peterson]

Take a look at application.macrooptoins in VBA's help:

Application.MacroOptions Macro:="myMacro", _
HasShortcutKey:=True, ShortcutKey:="U"