| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assign Shortcuts
Shortcut keys must be letters.
-- Gary''s Student - gsnu200815 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign keyboard shortcuts | Excel Worksheet Functions | |||
| OnKey - usable to assign new shortcuts to existing Excel keyboardshortcuts? | Excel Programming | |||
| Assign different keyboard shortcuts | Excel Programming | |||
| Can I assign keyboard shortcuts for special characters in Excel 20 | Excel Discussion (Misc queries) | |||
| Excel 2003 assign keyboard shortcuts to specific special character | Excel Discussion (Misc queries) | |||
Linear Mode
