Excel 2007 : Ribbon Tab Sequence Change in Excel 2007

**jasminpatel8178** · 10-24-2011, 03:45 PM

Hello everyone .. Please help me to save my job !!

Test Data Template is my Tab in the Ribbon of the excel 2007.
My Task it to;
1) Put this new tab at 1 st in Ribbon (place of Home) – or
2) Change the color and make it unique from other tab of ribbon or.
3) Make it as active tab.
I have to implement atleast one to save my job.

**quekbc** · 10-25-2011, 03:36 AM

Hi jasminpatel8178,

I'm assuming you've used CustomUI to add the additional tab.

You will need to use insertBeforeMso="TabHome" within <tab>

**Andy Pope** · 10-25-2011, 03:53 AM

See Tony Jollan's article on how to activate a tab.
http://www.wordarticles.com/Shorts/R...bonVBADemo.php

You can not alter the colour of the tab, only the caption.

**jasminpatel8178** · 10-25-2011, 11:51 AM

thanks man !!

it's done now .. thanks a lot for your valuable advise ...

can you help me with task 2 .. change the tab color in a ribbion .. but just for 1 tab
1 tab has seperate unique and rest all has default color .,, is it feasible?