I am using VSTO Deveopment | Excel 2007 | WITH#. Is there any event to determine that the tab selection in the excel ribbon has changed?
No .
VSTO2010 adds the ability to programmatically switch the selected tab. Norm Estabrook blog about it.
this.RibbonUI.ActivateTabMso("TabAddIns");
, , , , . , ; , . .