Add shortcut keystroke to existing macro?

[Ed]

Is there a simple line of code I can add to an existing macro to assign a
shortcut keystroke to it?

Thank you.
Ed

 

[scott]

You can go to Macro/Play Macro/Options and enter a shortcut key there

 

[Ed]

Thanks, Scott. I appreciate the help.

Ed

You can go to Macro/Play Macro/Options and enter a shortcut key there

 

[Jim Rech]

You can permanently assign a Ctrl shortcut to a macro (as long as you save
the workbook after running this) like this:

Application.MacroOptions Macro:="Test",ShortcutKey:="j"

or you can use OnKey to make it last for just the current Excel session:

Application.OnKey "^j", "Test"