Activate Custom Toolbar (Add-Ins) at Excel Workbook Opening

[mmrm]

Is there any way to open a workbook with Add-Ins menu activated which has my custom command bar and buttons?
Excel usually opens with Home menu active, I'd make it change to Add-Ins menu active while I open my workbook. Any help?
I've spent a lot of time searching for any vba code for this. Nothing found. Excel macro recorder does not record any menu clicks so could not get any help there too.
Thank you.

 

[Domenic]

First, add the following XML code to your workbook...

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" onLoad="Initialize"/>

If you need help in adding the XML code to your workbook, have a look at the following link...

How to Add Custom Tab for Specific Workbook on Excel Ribbon

How to add a custom tab to the Excel Ribbon. Custom tab appears when specific workbook is opened, hidden for other workbooks. Get the free Excel file

www.contextures.com

Then, add the following VBA code in a regular module (Visual Basic Editor >> Insert Module)...

Option Explicit

Public MyRibbon As IRibbonUI

Public Sub Initialize(ribbon As IRibbonUI)
'
' Code for Initialize callback.
'
    Set MyRibbon = ribbon
    
    MyRibbon.ActivateTabMso "TabAddIns"
    
End Sub

Now, save, close, and re-open your workbook.

Hope this helps!

 

[mmrm]

Thank you Domenic. I will try it and let you know. Thanks a lot for your response.