Changing shortcut keys on macros

W

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
 
I

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
 
D

Dave Peterson

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

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