How do I change the shortcut key for a macro

[Guest]

I would like to be able to change the shortcut key in an EXCEL macro without
having to re-write the whole macro.
Any help is appreciated.
Thank you.

 

[Guest]

select the macro in Tolls=>Macros=>Macros and select Options. Change it in
the dialog.

 

[Guest]

Hi Tom,
Thanks for your prompt reply. I had actually tried that before. When I first
recorded the macro a screen came up saying "Could not record" or similar.
However, when I viewed the macro the info was all there. The macro would not
run with the shortcut I had picked initially but it worked exactly as
required when I used the 'Run' command. I thought I had picked a "Reserved"
shortcut or something. I changed it again when I received your reply but it
is still the same. It will only work when I use the 'Run' command. If you
have any further ideas it/they would be gratefully received.
Regards
Tony Borg

 

[Tom Ogilvy]

Are you paying attention to the case of the letter?

you can also use the OnKey function to assign it to a shortcut key for that
instance of excel.

Using Run has nothing to do with the shortcut key.