Keyboard shortcut values displayed on custom ribbon

  • Thread starter Thread starter Cresta
  • Start date Start date
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
 
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
Office 2007 get ribbon name 6
Custom Images not showing in Ribbon toggle button 2
Linking a Ribbon control with an help file 3
Macro Fault on Custom Ribbon 5
Unable to change "Enabled" state of an Excel 2007 ribbon gallery b 4
Excel ribbon problem with Quick access toolbar 7
Button image not loading on Custom Ribbon 2

Back
Top