| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign macro to shortcut keys "ctrl + 1"?
Excel 2007 - is it possible to assign macros to shortcut keys such as
Ctrl +1, Ctrl +2 etc? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assign macro to shortcut keys "ctrl + 1"?
Hello
No you can't, shorcut keys expect letters. HTH Cordially Pascal "Johan" a écrit dans le message de news: ... Excel 2007 - is it possible to assign macros to shortcut keys such as Ctrl +1, Ctrl +2 etc? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assign macro to shortcut keys "ctrl + 1"?
Application.OnKey "^1", "myMacro"
Application.OnKey "^1" ' to clear it Some users might not appreciate your hi-jacking the built-in shortcut for the format menu! Regards, Peter T "Johan" wrote in message ... Excel 2007 - is it possible to assign macros to shortcut keys such as Ctrl +1, Ctrl +2 etc? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut for "Ctrl+Shift+1" | Excel Discussion (Misc queries) | |||
| "Show shortcut keys in ScreenTips" check box | Setting up and Configuration of Excel | |||
| "program shortcut keys in Excel" | Excel Programming | |||
| Excel shortcut key "Cut" Ctrl+X come up a formula to me why? | Excel Discussion (Misc queries) | |||
| not getting the "assign macro" shortcut | Excel Programming | |||
![Johan[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
