Keyboard shortcut values displayed on custom ribbon

C

Cresta

Hello All
I have successfully got Excel to open up on a custom tab using
Application.Sendkeys "%Y" when the ribbon is initialised. However, the "alt"
values are shown over the custom ribbon controls.
I have tried using Application.Sendkeys {ESC}{ESC} but nothing happens. They
do dissapear when the mouse is clicked or the keboard pressed.
Any ideas how to code this to make them dissapear before all opening scripts
have completed.

Thanks
 
J

Jim Rech

Press Alt again:

"%Y%"

--
Jim
| Hello All
| I have successfully got Excel to open up on a custom tab using
| Application.Sendkeys "%Y" when the ribbon is initialised. However, the
"alt"
| values are shown over the custom ribbon controls.
| I have tried using Application.Sendkeys {ESC}{ESC} but nothing happens.
They
| do dissapear when the mouse is clicked or the keboard pressed.
| Any ideas how to code this to make them dissapear before all opening
scripts
| have completed.
|
| Thanks
|
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Outlook 2013 custom ribbon based on item in the Reading Pane 0
Macro Fault on Custom Ribbon 5
How can I create custom controls on the ribbon in Excel 2007? 1
Ribbon: Controling Which Tab Shows With Each Form 1
Custom Ribbon Screentips Are Unprofessional in Access 2007 4
Form Region, Task Pain, Ribbon Extension - which way is best? 1
place button on ribbon for compose & read message 3
microsoft excel 2007 keyboard shortcut for file menu 2

Top