How do you assign a short-cut key to an existing macro. Whenever I do so
using the macro recorder, the only proof I have that a key exists is in a
commented section such as:

' Keyboard Shortcut: Ctrl+p

I need to apply something to an exisiting macro. How do I do this without
going through the record process just to set up the short cut and then
pasting my exisitng macro inside the module. It there a way using code to
program this into the module?

Thanks

EM

Tools->Macro->Macros, or press F8

You will see a list of macros found in all open workbooks and your personal
workbook. Select the one you like then click the Options button.



--

Hope that helps.

Vergel Adriano


"ExcelMonkey" wrote:

> How do you assign a short-cut key to an existing macro. Whenever I do so
> using the macro recorder, the only proof I have that a key exists is in a
> commented section such as:
>
> ' Keyboard Shortcut: Ctrl+p
>
> I need to apply something to an exisiting macro. How do I do this without
> going through the record process just to set up the short cut and then
> pasting my exisitng macro inside the module. It there a way using code to
> program this into the module?
>
> Thanks
>
> EM