Add-in ribbon refresh

[sgeogheg]

<gs id="28b0a239-72b7-439a-8a4b-ec6aaf77d1e8" ginger_software_uiphraseguid="ebb3d3e2-4831-4374-a900-d0c202674f4e" class="GINGER_SOFTWARE_mark">Hi I</gs> have created and a <gs id="b534475a-8789-4d1c-9010-9f1fbac4aac2" ginger_software_uiphraseguid="ebb3d3e2-4831-4374-a900-d0c202674f4e" class="GINGER_SOFTWARE_mark">xlam</gs> Add-in. Clicking a button on the ribbon bar creates a new Workbook, and inserts a number of sheets. What I find is, that in the new <gs id="d5e3ec9e-bb50-4265-9d45-9f5b0f069c80" ginger_software_uiphraseguid="fc35e10c-7dc5-4587-81b6-e98d33842573" class="GINGER_SOFTWARE_mark">Worksheet</gs> my Add-in tab is not displayed until after all the code has completed executing.

This is a problem as I want to use Application<gs id="dde529d9-110a-46fa-9ac3-661249ad02e8" ginger_software_uiphraseguid="96026656-0ce1-4171-954d-a9786a34e246" class="GINGER_SOFTWARE_mark">.</gs>SendKeys "%Y1%" to select my Add-in Tab for the new worksheet. But as the tab is not visible this does not work.

Any Ideas on how to get around this will be gratefully received.

Cheers
Shaun

 

[RoryA]

Welcome to the forum.

You might try using Application.Ontime in your button's callback to run the actual processing code. That may allow the tab to show up. Alternatively use OnTime to call a routine that activates the tab. If you have 2010 or later you can avoid sendkeys and use the ActivateTab method instead, assuming you have an ****** callback storing a reference to the Ribbon.

 

[sgeogheg]

</gs>Welcome to the forum.

You might try using Application<gs id="a279de61-f303-42bd-a16e-12fc5b18830a" ginger_software_uiphraseguid="a5d0c487-c2fa-410c-a3b5-6c79e8e539db" class="GINGER_SOFTWARE_mark">.</gs><gs id="ad181e88-5737-4878-9ce3-22d59d2fa746" ginger_software_uiphraseguid="a5d0c487-c2fa-410c-a3b5-6c79e8e539db" class="GINGER_SOFTWARE_mark">Ontime</gs> in your button's callback to run the actual processing code. That may allow the tab to show up. Alternatively use <gs id="ae81762a-37dc-4c08-952a-f70c2dbc3e0d" ginger_software_uiphraseguid="73de0b7c-d948-4f17-a18c-e4dc49437dc8" class="GINGER_SOFTWARE_mark">OnTime</gs> to call a routine that activates the tab. If you have 2010 or later you can avoid <gs id="8ab37f68-c689-41fb-a676-0755f8177f70" ginger_software_uiphraseguid="ad1ff77d-66a6-41c6-9975-3faf129fd801" class="GINGER_SOFTWARE_mark">sendkeys</gs> and use the ActivateTab method instead, assuming you have an ****** callback storing a reference to the Ribbon<gs id="f23bfe49-0de4-40e2-b916-0024ce9e330f" ginger_software_uiphraseguid="ad1ff77d-66a6-41c6-9975-3faf129fd801" class="GINGER_SOFTWARE_mark">.</gs>

Thanks Rory this has helped a lot.