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

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

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

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

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

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

Hi John,

Im glad that helped you, but I dont really understand what you mean about
"reading" (printing) a list of all existing macro shortcuts.

Do you mean, that you would like to know which shortcuts are already in use?

Max
"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

Application.MacroOptions Macro:="DoRand", _
HasShortcutKey:=True, ShortcutKey:="Z"as an example. -- Regards,Tom
Ogilvy"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