Change Shortcut Key Programatically
Max,
Thanks, very sensible of course! The result is this:
Sub ChangeShortCut()
Application.MacroOptions Macro:="Macro3", _
ShortcutKey:="T"
End Sub
This I guess leads to another question.............how would I go about
"reading" (printing) a list of all existing macro shortcuts?
Thanks again
John
"Max Potters" wrote in message
...
Try recording a macro for this.
"John" wrote in message
...
Hi Tom,
Thanks for this. I'm aware of this manual method, but was wondering if
there is a way of doing this programatically?
Best regards
John
"Tom Ogilvy" wrote in message
...
Highlight the macro in Tools=Macro=Macros and hit the Options
button.
Make the assignment there.
--
Regards,
Tom Ogilvy
"John" wrote in message
...
Hi,
Does anyone know if you can change a macro's shortcut key
programatically?
If for instance I've already assign a macro to fire on CTRL+SHIFT+E,
how
could I change it to fire on say CRTL+SHIFT+T instead?
Have a good weekend
John
|