How to make my Custom ribbon tab to show on excel Startup

Add-in Express™ Support Service
That's what is more important than anything else

How to make my Custom ribbon tab to show on excel Startup
How to make my Custom ribbon tab to show on excel Startup 
Karthick Raja




Posts: 67
Joined: 2011-05-12
Hi,
i had created a Ribbon Tab using the Addin express. but now I am in need of When Workbook open the New Ribbon tab should be Selected Tab but Defaultly Home tab is selected How Can i Change it.

Thanks,
Karthick
Posted 14 Jul, 2011 08:02:35 Top
Andrei Smolin


Add-in Express team


Posts: 16846
Joined: 2006-05-11
Hi Karthick,

You can position your tab so that it is shown before the Home tab, set InsertBeforeIdMso="HomeTab".

Regards from Belarus (GMT+2),

Andrei Smolin
Add-in Express Team Leader
Posted 14 Jul, 2011 08:33:55 Top
Karthick Raja




Posts: 67
Joined: 2011-05-12
Hi,
i'm not need the Position i have to Activate that Tab while Excel Book open. it should be in Last Position.
but while open this tab should be active tab.
Thanks,
Karthick
Posted 14 Jul, 2011 10:07:21 Top
Andrei Smolin


Add-in Express team


Posts: 16846
Joined: 2006-05-11
Preserve the IRibbonUI provided in the OnRibbonLoaded event of the module and call IRibbonUI.ActivateTab(ADXRibbonTab.Id). This will work in Office 2010 only; the Office 2007 Ribbon doesn't support this.

Regards from Belarus (GMT+2),

Andrei Smolin
Add-in Express Team Leader
Posted 14 Jul, 2011 10:14:45 Top
Karthick Raja




Posts: 67
Joined: 2011-05-12
Hi,
I had used but it shows Error "Reference to a Non shared Member Requires an Object Reference" Could You Please Help me.
Posted 14 Jul, 2011 23:13:36 Top
Andrei Smolin


Add-in Express team


Posts: 16846
Joined: 2006-05-11
Hi Karthick,

You need to create a variable of the IRibbonUI type on the class level and assaign it the value supplied in the OnRibbonLoaded event. Then you call IRibbonUI.ActivateTab(ADXRibbonTab.Id) in the AddinStartupComplete event.

Regards from Belarus (GMT+2),

Andrei Smolin
Add-in Express Team Leader
Posted 15 Jul, 2011 10:14:02 Top