Shortcut key to VB macro

J

Joe

Hi,

Once I create a macro in an Excel workbook using Visual basic, how can
I assign a shortcut key to that macro?

Thanks,

Joe.
 
D

Dave Peterson

Tools|macro|Macros
Select your macro
Click Options
Assign it a nice shortcut key
click ok
click cancel (to leave that dialog)

Remember to save the workbook with the macro--so that the shortcut key gets
remembered.
 
G

Gary''s Student

In the wroksheet, pull-down:

Tools > Macro > Macros...
slect you macro and touch options and assign the key
 
O

OZDOC1050

<< TOOLS > MACRO > MACRO'S >> select the macro you wish to add the shortcut
key to then select << OPTIONS >> if you want to have the Ctrl Shift option
place caps lock on first.

cheers
Pete
 
Top