ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Remove All Tabs from Ribbon except Custom Tab (https://www.excelbanter.com/excel-programming/417773-remove-all-tabs-ribbon-except-custom-tab.html)

RyanH

Remove All Tabs from Ribbon except Custom Tab
 
I virtually know nothing about XML. I would like to remove all the tabs from
the ribbon except my Custom Tab, how can I do this?

This is what I have in the Microsoft Office Custom UI:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
<ribbon
<tabs
<tab idMso="TabHome" visible="false"/
<tab idMso="TabInsert" visible="false"/
<tab idMso="TabPageLayout" visible="false"/
<tab idMso="TabFormulas" visible="false"/
<tab idMso="TabData" visible="false"/
<tab idMso="TabReview" visible="false"/
<tab idMso="TabView" visible="false"/
<tab idMso="TabDeveloper" visible="false"/
<tab id="customTab" label="AdTech" insertAfterMso="Developer"
<group id="customGroup" label="Global Production Schedule"
<button id="custombutton1" label="Import Macola Data" size="large"
onAction="a" imageMso="ImportExcel" /
<button id="custombutton2" label="Send To Archive" size="large"
onAction="a" imageMso="Piggy" / <button id="custombutton4"
label="Sort by Sales Order" size="large" onAction="a" imageMso="Grouping" /
<button id="custombutton3" label="Create Ready Schedule" size="large"
onAction="a" imageMso="NewTask" /
<button id="custombutton5" label="Create Sales Schedule" size="large"
onAction="a" imageMso="AccountMenu" /
<button id="custombutton6" label="Compile Dept. Schedules" size="large"
onAction="a" imageMso="FormsMenu" /
</group
</tab
</tabs
</ribbon
</customUI
--
Cheers,
Ryan

Gary Keramidas

Remove All Tabs from Ribbon except Custom Tab
 
don't use 2007, but does ron's site help?

http://www.rondebruin.nl/ribbon.htm

--


Gary

"RyanH" wrote in message
...
I virtually know nothing about XML. I would like to remove all the tabs
from
the ribbon except my Custom Tab, how can I do this?

This is what I have in the Microsoft Office Custom UI:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
<ribbon
<tabs
<tab idMso="TabHome" visible="false"/
<tab idMso="TabInsert" visible="false"/
<tab idMso="TabPageLayout" visible="false"/
<tab idMso="TabFormulas" visible="false"/
<tab idMso="TabData" visible="false"/
<tab idMso="TabReview" visible="false"/
<tab idMso="TabView" visible="false"/
<tab idMso="TabDeveloper" visible="false"/
<tab id="customTab" label="AdTech" insertAfterMso="Developer"
<group id="customGroup" label="Global Production Schedule"
<button id="custombutton1" label="Import Macola Data" size="large"
onAction="a" imageMso="ImportExcel" /
<button id="custombutton2" label="Send To Archive" size="large"
onAction="a" imageMso="Piggy" / <button id="custombutton4"
label="Sort by Sales Order" size="large" onAction="a" imageMso="Grouping"
/
<button id="custombutton3" label="Create Ready Schedule" size="large"
onAction="a" imageMso="NewTask" /
<button id="custombutton5" label="Create Sales Schedule" size="large"
onAction="a" imageMso="AccountMenu" /
<button id="custombutton6" label="Compile Dept. Schedules" size="large"
onAction="a" imageMso="FormsMenu" /
</group
</tab
</tabs
</ribbon
</customUI
--
Cheers,
Ryan





All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com