10 thoughts on “Hide or display Custom Ribbon Tabs, Groups or Controls with VBA code”

1. Hi Ron,

   Can this be used to hide Contextual Tabs as well

   Sam

2. Hi Sam

   After you add this to the RibbonX for the tab you see when you select a Table

   You can not use the id like this

   Call Set_Enabled_Visible(Vis:=True, myId:="TabSetTableToolsExcel")

   But must use this to do the reload every getVisible in the RibbonX

   Call Set_Enabled_Visible(Vis:=True, myId:="")

   I hope you can see it because I always have problems to post xml.
   Send me a private mail if you not see it

   Ron

3. Again

   Hi Sam

   After you add this to the RibbonX for the tab you see when you select a Table

    

   You can not use the id like this

   Call Set_Enabled_Visible(Vis:=True, myId:=”TabSetTableToolsExcel”)

   But must use this to do the reload every getVisible in the RibbonX

   Call Set_Enabled_Visible(Vis:=True, myId:=”“)

   I hope you can see it because I always have problems to post xml.
   Send me a private mail if you not see it

   Ron

4. Hi Sam

   I try it again (last time I promise)

   After you add this to the RibbonX for the tab you see when you select a Table

   [XML]

   [/XML]

   You can not use the id like this

   Call Set_Enabled_Visible(Vis:=True, myId:=”TabSetTableToolsExcel”)

   But must use this to do the reload every getVisible in the RibbonX

   Call Set_Enabled_Visible(Vis:=True, myId:=”“)

   I hope you can see it because I always have problems to post xml.
   Send me a private mail if you not see it

   Ron

5. Sam: In the download on the site I add a example for you.
   if you need more help post back

   Dick: please tell me how to post xml in thi comments

6. with [ xml ] tags, I think. Let’s see

   <big tag value=1>
       <little tag>value</little>
   </big>

7. Hi Ron,

   This is absolutely fantastic…. Great work. All the while I thought hiding contextual tabs was impossible…you have made it possible !

   Sam

8. Hi all

   I Add/Update the workbooks on the page
   http://www.rondebruin.nl/hidevisible.htm

   Because of problems whith running the code from events I change all the code.

   There is also two new workbooks now

   Different-Tab-For-Each-Worksheet.xlsm

   Hide-Display-Built-in Tabs.xlsm

   Read the information on the page and in the workbooks

   Regards Ron

9. Hi Ron,

   Might I say your Hide/Display Built-in Ribbon tabs with a macro is what I have been looking for!!! Have not gotten it to work the way I need it but it is very helpful.

   For the RibbonX Hide/Display Built-in Ribbon tabs, is there a way to add contextual tab and further control what is visible under the group of that contextual tab. For example, I am trying to get the PivotchartTools to be visible along with Design,Layout,Format,Analyze. My question is, how can I further control what is visible under the Design,Layout,Format,Analyze.

   The only way I can make it visible is by setting: , which I don’t think it is the right way to do it.

   How do I go about adding the Pivot Chart Tools contextual tab code to the Hid/Display Built-in Ribbons so I can control it with a macro.

   thanks in advance for all your help.
   tri

   ***********************************************************************************************************************

   <!– –>

   ***********************************************************************************************************************

10. Hi Tri

    Drop me a private mail and I try to help you next week.
    You can find my mail address on my site
    http://www.rondebruin.nl/

Posting code? Use <pre> tags for VBA and <code> tags for inline.