Need help in Excel AddIn development issue

Currently I am working on Excel AddIn development using Visual Studio 2012, .Net framework 4.0, VSTO and Excel 2010.

 

I have developed a custom BackStage view under File menu.

The scenario: I want to navigate user to BackStage screen each time when he opens an excel file. By default, excel opens "Home" tab and "Sheet1" is selected.

I tried using SendKeys("%F") etc. from C# AddIn code, but it does not work consistently.

 

Has anyone came across such situation? If anyone worked on related issue earlier or have some idea how to achieve this, please share it with me.

SOLUTION 1:

Use the below code in the Ribbon Load. “TabAddIns” is a control ID which I have in my property, check in your tab property and give the same in the below code.

 

this.RibbonUI.ActivateTabMso("TabAddIns");