Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In an Excel 2007 Workbook I'd like to redirect or capture the ALT+1, ALT+2,
ALT+3, etc. key stroke combinations to run some navigation routines I've written. I've tried using the following in the Workbook.Open event. Application.OnKey "%{1}", "sNavigateToGroup1" Application.OnKey "%{2}", "sNavigateToGroup2" Application.OnKey "%{3}", "sNavigateToGroup3" Application.OnKey "%{4}", "sNavigateToGroup4" Application.OnKey "%{5}", "sNavigateToGroup5" Application.OnKey "%{6}", "sNavigateToGroup6" This doesn't work. If anyone has experience with this type of routine or can point me in the right direction, I'd be very appreciative. TIA, Ken |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Redirecting | Excel Discussion (Misc queries) | |||
Redirecting | Setting up and Configuration of Excel | |||
Redirecting | Excel Programming | |||
redirecting personal.xls | Excel Discussion (Misc queries) | |||
Redirecting macros ... | Excel Programming |