E Ed Dec 10, 2003 #1 Is there a simple line of code I can add to an existing macro to assign a shortcut keystroke to it? Thank you. 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
E Ed Dec 10, 2003 #3 Thanks, Scott. I appreciate the help. Ed scott said: You can go to Macro/Play Macro/Options and enter a shortcut key there Click to expand...
Thanks, Scott. I appreciate the help. Ed scott said: You can go to Macro/Play Macro/Options and enter a shortcut key there Click to expand...
J Jim Rech Dec 10, 2003 #4 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"
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"
