none
How to hide only the 'Add-Ins' tab? RRS feed

  • Question

  • I need to programmatically:

    • Hide just the "Add-Ins" tab with its CommandBars content, so that remaining built-in tabs plus my custom Ribbon tabs appear.
    • Keep the Add-Ins tab active (functional), as my custom Ribbon needs to access business logic associated with it.
    Although this is Excel 2010, I assume the approach would be the same for any Office 14 project.

    Can I avoid using <startFromScratch> to hide the Add-Ins tab? The examples I've seen of it don't include how to add back in built-in tabs-- a short example showing how  this is done would be very helpful.

    Additionally, use of <startFromScratch> would seem to restrict the user from having access to anyone else's Ribbon customizations.

    I didn't find an answer among the existing forum questions.

    Thursday, August 18, 2011 4:00 PM

Answers

  • Hide the Add-ins tab:

    <

    tab idMso="TabAddIns" visible="false" >

    If you want to hide/show it dynamically, then use the getVisible attribute with its callback to return the appropriate boolean value. And Ribbon.Invalidate() to force the "get" callbacks to re-evaluate in the entire Ribbon.


    Cindy Meister, VSTO/Word MVP
    • Marked as answer by Anonymous9748 Thursday, August 18, 2011 5:41 PM
    Thursday, August 18, 2011 5:30 PM
    Moderator

All replies

  • Hide the Add-ins tab:

    <

    tab idMso="TabAddIns" visible="false" >

    If you want to hide/show it dynamically, then use the getVisible attribute with its callback to return the appropriate boolean value. And Ribbon.Invalidate() to force the "get" callbacks to re-evaluate in the entire Ribbon.


    Cindy Meister, VSTO/Word MVP
    • Marked as answer by Anonymous9748 Thursday, August 18, 2011 5:41 PM
    Thursday, August 18, 2011 5:30 PM
    Moderator
  • Thanks, Cindy!
    Thursday, August 18, 2011 5:41 PM