Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2003
Sorry if this is a repeat post. Google Groups seems to take posts about 2/3 of the time. Anyway... It appears that Application.OnKey can do only the three following tasks: - Remove the assignment of an Excel keyboard shortcut. - Restore that assignment. - Assign a keyboard shortcut to a **MACRO**. Can it also be used to assign a customized keyboard shortcut to an ordinary Excel feature? For example, I'd like to assign F3 to "Find Next" (whose default shortcut is Shift-F4; I often end up hitting Ctrl- F4 and closing the workbook). I'd lose the existing functionality of F3, but I never use it anyway. If not OnKey, is there another VBA Method that would do this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assign keyboard shortcuts | Excel Worksheet Functions | |||
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) | |||
assign onkey to 1 worksheet | Excel Programming |