How do I customize keyboard shortcuts in Excel 2007

[Ian W]

I can create a keyboard shortcut when recording a macro. How do I assign a
shortcut to a macro I have already typed up or copied?
Thanks,

 

[Roger Govier]

Hi Ian

Tools>Macros>Macros>highlight macro required>Options

 

[Andy Pope]

Hi,

For 2007.
Developer > Code > Macros > Options.

Cheers
Andy

 

[Ian W]

Thanks Roger. What doesn't seem to have displayed in the thread was that I
am looking at Excel 2007. The important words were dropped of the end of my
subject. However, I have found it. On the Developer Tab>Macros>highlight
macro required>Options
Thanks very much,
--
Ian W
South Africa

Hi Ian

Tools>Macros>Macros>highlight macro required>Options

 

[Roger Govier]

Sorry Ian, I didn't read your title properly.
You did say Excel 2007.

--
Regards
Roger Govier

Thanks Roger. What doesn't seem to have displayed in the thread was that
I
am looking at Excel 2007. The important words were dropped of the end of
my
subject. However, I have found it. On the Developer Tab>Macros>highlight
macro required>Options
Thanks very much,