Assign short-cut key to existing macro
 

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

Assign short-cut key to existing macro
 

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