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
Hi Ron,
Can this be used to hide Contextual Tabs as well
Sam
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
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
But must use this to do the reload every getVisible in the RibbonX
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
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
But must use this to do the reload every getVisible in the RibbonX
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
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
with [ xml ] tags, I think. Let’s see
<little tag>value</little>
</big>
Hi Ron,
This is absolutely fantastic…. Great work. All the while I thought hiding contextual tabs was impossible…you have made it possible !
Sam
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
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
***********************************************************************************************************************
<!– –>
***********************************************************************************************************************
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/