Assign short-cut key to existing macro

E

ExcelMonkey

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
 
V

Vergel Adriano

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top