View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default 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