View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Max Potters Max Potters is offline
external usenet poster
 
Posts: 43
Default Change Shortcut Key Programatically

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