Assign Shortcuts
 

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!

Assign Shortcuts
 

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

Assign Shortcuts
 

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!

Assign Shortcuts
 

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

Assign Shortcuts
 

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