Redirecting ALT+1 keystrokes to run routine
in [Programming]
|
From: Ken Warthen on 26 Mar 2010 16:09 Thanks for the advice. I switched to CTL and everything is working fine. Ken "Peter T" wrote: > Looks like you only assign Alt-8 & 9 in 2007. But Ctrl-alt seems to work > with the others. Don't forget to omit the curly brackets > > Regards, > Peter T > > > "Ken Warthen" <KenWarthen(a)discussions.microsoft.com> wrote in message > news:5965DE99-2A31-4BAF-813A-FF5D35748E44(a)microsoft.com... > > 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 > > > > > . >
From: Peter T on 26 Mar 2010 16:34 FWIW Ctrl-1 is one of the most common built-in shortcuts I use, maybe your users too... Which is why I suggested Ctrl-Alt. Regards, Peter T "Ken Warthen" <KenWarthen(a)discussions.microsoft.com> wrote in message news:712674ED-D9C4-4DFD-BD3C-BB0D41CD180F(a)microsoft.com... > Thanks for the advice. I switched to CTL and everything is working fine. > > Ken > > "Peter T" wrote: > >> Looks like you only assign Alt-8 & 9 in 2007. But Ctrl-alt seems to work >> with the others. Don't forget to omit the curly brackets >> >> Regards, >> Peter T >> >> >> "Ken Warthen" <KenWarthen(a)discussions.microsoft.com> wrote in message >> news:5965DE99-2A31-4BAF-813A-FF5D35748E44(a)microsoft.com... >> > 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 >> > >> >> >> . >>
From: Ken Warthen on 26 Mar 2010 17:20 Thanks for the advice. I noticed my shortcuts work if I'm using the numbers at the top of the keyboard, but not if I'm using the number keys on the NumPad. Is there a fix for this too? Ken "Peter T" wrote: > FWIW Ctrl-1 is one of the most common built-in shortcuts I use, maybe your > users too... Which is why I suggested Ctrl-Alt. > > Regards, > Peter T > > "Ken Warthen" <KenWarthen(a)discussions.microsoft.com> wrote in message > news:712674ED-D9C4-4DFD-BD3C-BB0D41CD180F(a)microsoft.com... > > Thanks for the advice. I switched to CTL and everything is working fine. > > > > Ken > > > > "Peter T" wrote: > > > >> Looks like you only assign Alt-8 & 9 in 2007. But Ctrl-alt seems to work > >> with the others. Don't forget to omit the curly brackets > >> > >> Regards, > >> Peter T > >> > >> > >> "Ken Warthen" <KenWarthen(a)discussions.microsoft.com> wrote in message > >> news:5965DE99-2A31-4BAF-813A-FF5D35748E44(a)microsoft.com... > >> > 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 > >> > > >> > >> > >> . > >> > > > . >
From: Peter T on 26 Mar 2010 18:31
I don't think Onkey works with the number pad in any version. Regards, Peter T "Ken Warthen" <KenWarthen(a)discussions.microsoft.com> wrote in message news:F50FAE06-1E01-4537-952D-E47F7D7CEDBC(a)microsoft.com... > Thanks for the advice. I noticed my shortcuts work if I'm using the > numbers > at the top of the keyboard, but not if I'm using the number keys on the > NumPad. Is there a fix for this too? > > Ken > > "Peter T" wrote: > >> FWIW Ctrl-1 is one of the most common built-in shortcuts I use, maybe >> your >> users too... Which is why I suggested Ctrl-Alt. >> >> Regards, >> Peter T >> >> "Ken Warthen" <KenWarthen(a)discussions.microsoft.com> wrote in message >> news:712674ED-D9C4-4DFD-BD3C-BB0D41CD180F(a)microsoft.com... >> > Thanks for the advice. I switched to CTL and everything is working >> > fine. >> > >> > Ken >> > >> > "Peter T" wrote: >> > >> >> Looks like you only assign Alt-8 & 9 in 2007. But Ctrl-alt seems to >> >> work >> >> with the others. Don't forget to omit the curly brackets >> >> >> >> Regards, >> >> Peter T >> >> >> >> >> >> "Ken Warthen" <KenWarthen(a)discussions.microsoft.com> wrote in message >> >> news:5965DE99-2A31-4BAF-813A-FF5D35748E44(a)microsoft.com... >> >> > 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 >> >> > >> >> >> >> >> >> . >> >> >> >> >> . >> |