VBA code for switching between Main tabs

[A_Holy_Bartender]

Greetings.

I am writing a custom tab ribbon and I discovered that sometimes the program will switch to "Home" tab. I would like to add a command line that will assure that the program will remain in my custom ribbon tab.

any Ideas?

thanks.

 

[eddvrs]

From what I can tell, you can't do this with the standard Excel set-up.

I found these links <a href="http://stackoverflow.com/questions/19967283/excel-hide-show-all-tabs-on-ribbon-except-custom-tab">here</a> and <a href="http://www.mrexcel.com/forum/excel-questions/634951-activate-given-tab-ribbon.html">here</a> where others have asked the same question (see search tool)