software

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

Joe wrote:
gt;
gt; Hi,
gt;
gt; Once I create a macro in an Excel workbook using Visual basic, how can
gt; I assign a shortcut key to that macro?
gt;
gt; Thanks,
gt;
gt; Joe.

--

Dave Peterson

In the wroksheet, pull-down:

Tools gt; Macro gt; Macros...
slect you macro and touch options and assign the key
--
Gary's Studentquot;Joequot; wrote:

gt; Hi,
gt;
gt; Once I create a macro in an Excel workbook using Visual basic, how can
gt; I assign a shortcut key to that macro?
gt;
gt; Thanks,
gt;
gt; Joe.
gt;
gt;

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

cheers
Pete

--
(][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)
quot;Joequot; gt; wrote in message ups.com...
gt; Hi,
gt;
gt; Once I create a macro in an Excel workbook using Visual basic, how can
gt; I assign a shortcut key to that macro?
gt;
gt; Thanks,
gt;
gt; Joe.
gt;
Dave, Pete, Gary's student, Thanks a lot !

- Joe.