Hi,

If I have ten different macros …

I need to assign shortkeys Ctrl 1, Ctrl 2 …. Crl 10 to the macors…

Please help me solve this...

Thanks!

Shortcut keys must be letters.
--
Gary''s Student - gsnu200815

Hi,

Tools|Options|Macros

Navigate to your macro in the window and select it. Click 'Options' and
assign your shortcut.

Mike

"Boss" wrote:

> Hi,
>
> If I have ten different macros …
>
> I need to assign shortkeys Ctrl 1, Ctrl 2 …. Crl 10 to the macors…
>
> Please help me solve this...
>
> Thanks!
>

I wish to do it using number...

I can do it using keypad number but cannot using numpad number...

using code

Application.OnKey "^1", "Mymacro"


Thanks!

Boss
"Gary''s Student" wrote:

> Shortcut keys must be letters.
> --
> Gary''s Student - gsnu200815

Sub macro6()
Application.OnKey "^{END}", "hello"
End Sub

will work on the numeric keypad, but only with NUMLOCK off.
--
Gary''s Student - gsnu200815


"Boss" wrote:

> I wish to do it using number...
>
> I can do it using keypad number but cannot using numpad number...
>
> using code
>
> Application.OnKey "^1", "Mymacro"
>
>
> Thanks!
>
> Boss
> "Gary''s Student" wrote:
>
> > Shortcut keys must be letters.
> > --
> > Gary''s Student - gsnu200815