title: Excel Hide/Show all tabs on Ribbon except custom tab
body: <p>How can I hide and show all the standard Excel ribbon tabs using VBA (not XML). I do not want to hide the whole ribbon (as is asked here: <a href="https://stackoverflow.com/questions/19019546/vba-minimize-ribbon-in-excel?rq=1">VBA minimize ribbon in Excel</a>) just the tabs. I know how to use startFromScratch using XML so please do not suggest that or other XML solutions. </p>
  
  <p>So far I have done an extensive Google search and looked at:</p>
  
  <ul>
  <li><a href="http://msdn.microsoft.com/en-us/library/office/ee390805(v=office.11).aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/library/office/ee390805(v=office.11).aspx</a></li>
  <li><a href="http://msdn.microsoft.com/en-us/library/microsoft.office.tools.ribbon.officeribbon.startfromscratch.aspx?cs-save-lang=1&amp;cs-lang=vb#code-snippet-1" rel="noreferrer">http://msdn.microsoft.com/en-us/library/microsoft.office.tools.ribbon.officeribbon.startfromscratch.aspx?cs-save-lang=1&amp;cs-lang=vb#code-snippet-1</a></li>
  <li><a href="https://stackoverflow.com/questions/18522048/customizing-a-ribbon-with-vba-in-excel">Customizing a ribbon with VBA in Excel</a></li>
  <li><a href="https://stackoverflow.com/questions/3527645/show-excel-2007-ribbon-in-xls-file-using-excel-vba">Show Excel 2007 Ribbon in XLS file using Excel VBA</a></li>
  <li><a href="https://stackoverflow.com/questions/3527645/show-excel-2007-ribbon-in-xls-file-using-excel-vba">Show Excel 2007 Ribbon in XLS file using Excel VBA</a></li>
  <li><a href="https://stackoverflow.com/questions/1867982/ribbon-gui-guidelines">Ribbon GUI Guidelines</a></li>
  <li><a href="https://stackoverflow.com/questions/15509769/excel-customui-ribbon-layout">Excel CustomUI ribbon layout</a></li>
  <li><a href="http://www.rondebruin.nl/win/s2/win012.htm" rel="noreferrer">http://www.rondebruin.nl/win/s2/win012.htm</a></li>
  </ul>
  
  <p>What I am saying is I have already done an extensive search and tried many things without getting a result.</p>