View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Change Shortcut Key Programatically

There is no such list available.

--
Regards,
Tom Ogilvy

"John" wrote in message
...
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