<< 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

--
(][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)
"Joe" wrote in message
ups.com...
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.