Hide or display Custom Ribbon Tabs, Groups or Controls with VBA code

Hi all

Today I upload a new page with examples to Hide or display Custom Tabs, Groups or Controls with VBA code

Hide or Display Custom Ribbon Tab/Group/Control with getVisible
http://www.rondebruin.nl/hidevisible.htm

If you have suggestions to make the examples better please let me know.
I am no expert but love to try new stuff like this.

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

Posted in Uncategorized

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

  1. 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

  2. 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

  3. 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

  4. 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

  5. Hi Ron,

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

    Sam

  6. 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

  7. 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

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

    <!– –>

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


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

Leave a Reply

Your email address will not be published.