Activate a given tab in the ribbon

[Stevenn]

Is there a way to activate either the Add-Ins tab or a custom tab in the ribbon when the workbooks opens? Maybe something like:

Private Sub Workbook_Activate()
  ActivateAddInsTab()
End Sub

 

[wigi]

Hello there

There is no other way than using SendKeys in VBA.
Send an Alt-... combination just as a manual shortcut would do.

 

[Andy Pope]

in xl2010 you can now activate tabs.

You need to create ribbon xml.
Note the extra space in order to stop forum converting stuff to ***

< customUI
xmlns="http://schemas.microsoft.com/office/2009/07/customui"
o nLoad="rbx_o nLoad"/>

and in a standard code module.

Public g_rbxUI As IRibbonUI
Public Sub rbx_o nLoad(ribbon As IRibbonUI)
'
' Code for ****** callback. Ribbon control customUI
'
    Set g_rbxUI = ribbon

    g_rbxUI.ActivateTabMso "TabAddIns"
    
End Sub

You can also use the approach explained by Tony Jollans that will work in xl2007+
http://www.wordarticles.com/Shorts/RibbonVBA/RibbonVBADemo.php

 

[wigi]

Thank you for the information Andy.

 

[Greg_M]

Years later, another grateful soul has found a solution in your words of wisdom! Many thanks, Andy.

Best regards,

Greg M