Prev: Loop by Group Within Group
Next: Excel VBA recommendations
From: Ken Warthen on 26 Mar 2010 12:14
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: Philosophaie on 26 Mar 2010 13:37
Hope Ron does not mind me using his site. Here is a compehenssive discuaaion
about Application.OnKey:

http://www.rondebruin.nl/key.htm

From: Ken Warthen on 26 Mar 2010 14:44
According to the link, the only thing I would need to do is remove the curly
brackets since the numeral keys are not considered special keys. I did so,
but the key combinations still do not work.

Anybody else have any ideas?

Ken

"Philosophaie" wrote:

> Hope Ron does not mind me using his site. Here is a compehenssive discuaaion
> about Application.OnKey:
>
> http://www.rondebruin.nl/key.htm
>
From: Peter T on 26 Mar 2010 15:21
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: Shane Devenshire on 26 Mar 2010 15:55
Hi,

I think Alt is a bad choice, why not try Ctrl+1...., that works fine for me.
Syntax is: "^1"

Possibly the problem with Alt is that it is the beginning of menu/ribbon
shortcut key activation, so if you press Alt+1 Excel assumes you want to run
the first QAT toolbar button. If instead you use Alt+B which is not an
assigned options it will work. The syntax being "%B"

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Ken Warthen" wrote:

> According to the link, the only thing I would need to do is remove the curly
> brackets since the numeral keys are not considered special keys. I did so,
> but the key combinations still do not work.
>
> Anybody else have any ideas?
>
> Ken
>
> "Philosophaie" wrote:
>
> > Hope Ron does not mind me using his site. Here is a compehenssive discuaaion
> > about Application.OnKey:
> >
> > http://www.rondebruin.nl/key.htm
> >
 |  Next  |  Last
Pages: 1 2
Prev: Loop by Group Within Group
Next: Excel VBA recommendations