Assign Shortcuts

[Boss]

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!

 

[Gary''s Student]

Shortcut keys must be letters.

 

[Mike H]

Hi,

Tools|Options|Macros

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

Mike

 

[Boss]

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]

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

will work on the numeric keypad, but only with NUMLOCK off.