Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon Custom Tab Focus
I am trying to set focus on one of a number of custom tabs.
I use the Keytip technique: 1. In XML - Define a Keytip 2. In VBA - Application.SendKeys "%ZYX{RETURN}" It works, however I also get a Beep, indicating some error. What could be the problem? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon Custom Tab Focus
Might not need {return} see if work without
"Dovy" wrote in message ... |I am trying to set focus on one of a number of custom tabs. | I use the Keytip technique: | 1. In XML - Define a Keytip | 2. In VBA - Application.SendKeys "%ZYX{RETURN}" | It works, however I also get a Beep, indicating some error. | What could be the problem? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon Custom Tab Focus
On Apr 15, 9:55*am, "Homey" <none wrote:
Might not need {return} see if work without "Dovy" wrote in message ... |I am trying to set focus on one of a number of custom tabs. | I use the Keytip technique: | 1. *In XML - Define a Keytip | 2. *In VBA - Application.SendKeys "%ZYX{RETURN}" | It works, however I also get a Beep, indicating some error. | What could be the problem? {Return} is necessary to get the focus away from the ribbon. I took me some time, but I found the problem. When you try to change focus with SendKeys technique, the tab get selected as soon as Excel detects a unique value. Since there is no other tab with keytip starting with Z, excel fired the selection when Z was sent, then complained with a beep when YX were sent. Manual operation using ALT+ works just fine with all three characters. Dovy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove All Tabs from Ribbon except Custom Tab | Excel Programming | |||
Custom ribbon dropdown | Excel Programming | |||
Custom menus don't appear under custom ribbon tab | Excel Programming | |||
no custom button in ribbon | Excel Programming | |||
Macro Fault on Custom Ribbon | Excel Programming |