Hide 2 buttons when 1 Button is selected

K

Kurt

Well-known Member
Joined
Jul 23, 2002
Messages
1,664
I have the following XML in a Custom Ribbon I have created


<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" ******="RibbonControl******">
<ribbon>
<tabs>
<tab id="tBreakdowns" label="Breakdowns">
<group id="gCustGrp1" label="Breakdowns" >
<button id="bSummary" size="large" label="Summary" imageMso="BlogHomePage"
screentip = "Summary" onAction="CallSummary"
supertip = "Displays the Summary information on the Copy Ready Worksheet"/>
<button id="bFloor" size="large" label="Floor" imageMso="AlignJustify"
screentip = "Floor" onAction="CallFloor"
supertip = "Displays the Floor information on the Copy Ready Worksheet"/>
<button id="bDrawing" size="large" label="Drawing" imageMso="BlogCategories"
screentip = "Drawing" onAction="CallDrawing"
supertip = "Displays the Drawing information on the Copy Ready Worksheet"/>
<button id="bZone" size="large" label="Zone" imageMso="AlignJustifyHigh"
screentip = "Zone" onAction="CallZone"
supertip = "Displays the Zone information on the Copy Ready Worksheet"/>
</group>
<group id="gCustGrp2" label="Import Data" tag="AdminGroup" >
<button id="bChooseImportFile" size="large" label="Choose Import File" imageMso="BlogPublish"
screentip = "Choose the file you need to import"
supertip = "Runs the Choose File macro" onAction="CallChooseFile"/>
<button id="bImportData" size="large" label="Import Data" imageMso="CollapseAll"
screentip = "Import Data" onAction="CallImportRawData"
supertip = "Runs the Import Data macro"/>
<button id="bHidAndSave" size="large" label="Hide Input Save As" imageMso="FileSave"
screentip = "Hide Input tab and Save As" onAction="CallImportRawData"
supertip = "Runs the Import Data macro"/>
</group>
<group id="AlternateBaseFilter" label="Base" >
<button id= "AlternateBase" label = "Alternate" size="large"
onAction="ShowBaseAlternateUserForm" screentip = "Toggles Alternate Values" imageMso="BlackAndWhiteInverseGrayscale"
supertip = "Switches Alternate field values between Alernate and Base" />
</group>
<group id="gInfo" label="Info" >
<button id= "bInfo" label = "Info" size="large"
onAction="ShowInfoForm" screentip = "Information" imageMso="Info"
supertip = "Show information about this file." />
</group>
</tab>
<tab id="tBreakdowns2" label="Breakdowns2">
<group id="gCustGrp3" label="Breakdowns2" >
<button id="bSummary2" size="large" label="Summary" imageMso="BlogHomePage"
screentip = "Summary" onAction="CallSummary"
supertip = "Displays the Summary information on the Copy Ready Worksheet"/>
<button id="bFloor2" size="large" label="Floor" imageMso="AlignJustify"
screentip = "Floor" onAction="CallFloor"
supertip = "Displays the Floor information on the Copy Ready Worksheet"/>
<button id="bDrawing2" size="large" label="Drawing" imageMso="BlogCategories"
screentip = "Drawing" onAction="CallDrawing"
supertip = "Displays the Drawing information on the Copy Ready Worksheet"/>
<button id="bZone2" size="large" label="Zone" imageMso="AlignJustifyHigh"
screentip = "Zone" onAction="CallZone"
supertip = "Displays the Zone information on the Copy Ready Worksheet"/>
</group>
<group id="AlternateBaseFilter2" label="Base" >
<button id= "AlternateBase2" label = "Alternate" size="large"
onAction="ShowBaseAlternateUserForm" screentip = "Toggles Alternate Values" imageMso="BlackAndWhiteInverseGrayscale"
supertip = "Switches Alternate field values between Alernate and Base" />
</group>
<group id="gInfo2" label="Info" >
<button id= "bInfo2" label = "Info" size="large"
onAction="ShowInfoForm" screentip = "Information" imageMso="Info"
supertip = "Show information about this file." />
</group>
</tab>
</tabs>
</ribbon>
</customUI>

When the HideInputSaveAs button is selected I want to hide the Choose Input File, Import File buttons or just show the Breakdowns2 Ribbon.

I have spent the last day and a half really learning a lot of great things on this but I have yet to find something that works.

I have even tried this:

Code: 
Sub hide_ribbon()
    Application.ExecuteExcel4Macro "show.toolbar(""Breakdowns"", False)"
End Sub

It will not work.

Any help is always greatly appreciated!
 
Last edited:

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Sort by date Sort by votes
'<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
'<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" ******="RibbonControl******">
' <ribbon>
' <tabs>
' <tab id="tBreakdowns" label="Breakdowns">
' <group id="gCustGrp1" label="Breakdowns" >
' <button id="bSummary" size="large" label="Summary" imageMso="BlogHomePage"
' screentip = "Summary" onAction="CallSummary"
' supertip = "Displays the Summary information on the Copy Ready Worksheet"/>
' <button id="bFloor" size="large" label="Floor" imageMso="AlignJustify"
' screentip = "Floor" onAction="CallFloor"
' supertip = "Displays the Floor information on the Copy Ready Worksheet"/>
' <button id="bDrawing" size="large" label="Drawing" imageMso="BlogCategories"
' screentip = "Drawing" onAction="CallDrawing"
' supertip = "Displays the Drawing information on the Copy Ready Worksheet"/>
' <button id="bZone" size="large" label="Zone" imageMso="AlignJustifyHigh"
' screentip = "Zone" onAction="CallZone"
' supertip = "Displays the Zone information on the Copy Ready Worksheet"/>
' </group>
' <group id="gCustGrp2" label="Import Data" tag="AdminGroup" >
' <button id="bChooseImportFile" size="large" label="Choose Import File" imageMso="BlogPublish"
' screentip = "Choose the file you need to import"
' supertip = "Runs the Choose File macro" onAction="CallChooseFile"/>
' <button id="bImportData" size="large" label="Import Data" imageMso="CollapseAll"
' screentip = "Import Data" onAction="CallImportRawData"
' supertip = "Runs the Import Data macro"/>
' <button id="bHidAndSave" size="large" label="Hide Input Save As" imageMso="FileSave"
' screentip = "Hide Input tab and Save As" onAction="CallImportRawData"
' supertip = "Runs the Import Data macro"/>
' </group>
' <group id="AlternateBaseFilter" label="Base" >
' <button id= "AlternateBase" label = "Alternate" size="large"
' onAction="ShowBaseAlternateUserForm" screentip = "Toggles Alternate Values" imageMso="BlackAndWhiteInverseGrayscale"
' supertip = "Switches Alternate field values between Alernate and Base" />
' </group>
' <group id="gInfo" label="Info" >
' <button id= "bInfo" label = "Info" size="large"
' onAction="ShowInfoForm" screentip = "Information" imageMso="Info"
' supertip = "Show information about this file." />
' </group>
' </tab>
' <tab id="tBreakdowns2" label="Breakdowns2">
' <group id="gCustGrp3" label="Breakdowns2" >
' <button id="bSummary2" size="large" label="Summary" imageMso="BlogHomePage"
' screentip = "Summary" onAction="CallSummary"
' supertip = "Displays the Summary information on the Copy Ready Worksheet"/>
' <button id="bFloor2" size="large" label="Floor" imageMso="AlignJustify"
' screentip = "Floor" onAction="CallFloor"
' supertip = "Displays the Floor information on the Copy Ready Worksheet"/>
' <button id="bDrawing2" size="large" label="Drawing" imageMso="BlogCategories"
' screentip = "Drawing" onAction="CallDrawing"
' supertip = "Displays the Drawing information on the Copy Ready Worksheet"/>
' <button id="bZone2" size="large" label="Zone" imageMso="AlignJustifyHigh"
' screentip = "Zone" onAction="CallZone"
' supertip = "Displays the Zone information on the Copy Ready Worksheet"/>
' </group>
' <group id="AlternateBaseFilter2" label="Base" >
' <button id= "AlternateBase2" label = "Alternate" size="large"
' onAction="ShowBaseAlternateUserForm" screentip = "Toggles Alternate Values" imageMso="BlackAndWhiteInverseGrayscale"
' supertip = "Switches Alternate field values between Alernate and Base" />
' </group>
' <group id="gInfo2" label="Info" >
' <button id= "bInfo2" label = "Info" size="large"
' onAction="ShowInfoForm" screentip = "Information" imageMso="Info"
' supertip = "Show information about this file." />
' </group>
' </tab>
' </tabs>
' </ribbon>
'</customUI>
 
Upvote 0
Here is the XML

Code: 
|<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
|<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" ******="RibbonControl******">
|  <ribbon>
|     <tabs>
|      <tab id="tBreakdowns" label="Breakdowns">
|         <group id="gCustGrp1" label="Breakdowns" >
|             <button id="bSummary" size="large" label="Summary" imageMso="BlogHomePage"
|                     screentip = "Summary" onAction="CallSummary" 
| 			  supertip = "Displays the Summary information on the Copy Ready Worksheet"/>
| 		<button id="bFloor" size="large" label="Floor" imageMso="AlignJustify"
|                     screentip = "Floor" onAction="CallFloor" 
| 			  supertip = "Displays the Floor information on the Copy Ready Worksheet"/>
|  		<button id="bDrawing" size="large" label="Drawing" imageMso="BlogCategories"
| 			  screentip = "Drawing" onAction="CallDrawing"
| 			  supertip = "Displays the Drawing information on the Copy Ready Worksheet"/>          
| 		<button id="bZone" size="large" label="Zone" imageMso="AlignJustifyHigh"
|                     screentip = "Zone" onAction="CallZone"
| 			  supertip = "Displays the Zone information on the Copy Ready Worksheet"/>                    
|         </group>
| 	  <group id="gCustGrp2" label="Import Data" tag="AdminGroup" >
|             <button id="bChooseImportFile" size="large" label="Choose Import File" imageMso="BlogPublish"
|                     screentip = "Choose the file you need to import"
| 			  supertip = "Runs the Choose File macro" onAction="CallChooseFile"/>    
| 		<button id="bImportData" size="large" label="Import Data" imageMso="CollapseAll"
| 			  screentip = "Import Data" onAction="CallImportRawData" 
| 		  	  supertip = "Runs the Import Data macro"/> 
| 		<button id="bHidAndSave" size="large" label="Hide Input Save As" imageMso="FileSave"
| 			  screentip = "Hide Input tab and Save As" onAction="CallImportRawData" 
| 		  	  supertip = "Runs the Import Data macro"/> 
|  	  </group>	
| 	  <group id="AlternateBaseFilter" label="Base" >
|    		<button id= "AlternateBase" label = "Alternate" size="large"  							  
| 			  onAction="ShowBaseAlternateUserForm" screentip = "Toggles Alternate Values" imageMso="BlackAndWhiteInverseGrayscale"
| 			  supertip = "Switches Alternate field values between Alernate and Base" /> 
|   	  </group>
| 	  <group id="gInfo" label="Info" >
|    		<button id= "bInfo" label = "Info" size="large"  							  
| 			  onAction="ShowInfoForm" screentip = "Information" imageMso="Info"
| 			  supertip = "Show information about this file." /> 
|   	  </group>
|       </tab>
|       <tab id="tBreakdowns2" label="Breakdowns2">
|         <group id="gCustGrp3" label="Breakdowns2" >
|             <button id="bSummary2" size="large" label="Summary" imageMso="BlogHomePage"
|                     screentip = "Summary" onAction="CallSummary" 
| 			  supertip = "Displays the Summary information on the Copy Ready Worksheet"/>
| 		<button id="bFloor2" size="large" label="Floor" imageMso="AlignJustify"
|                     screentip = "Floor" onAction="CallFloor" 
| 			  supertip = "Displays the Floor information on the Copy Ready Worksheet"/>
|  		<button id="bDrawing2" size="large" label="Drawing" imageMso="BlogCategories"
| 			  screentip = "Drawing" onAction="CallDrawing"
| 			  supertip = "Displays the Drawing information on the Copy Ready Worksheet"/>          
| 		<button id="bZone2" size="large" label="Zone" imageMso="AlignJustifyHigh"
|                     screentip = "Zone" onAction="CallZone"
| 			  supertip = "Displays the Zone information on the Copy Ready Worksheet"/>                    
|         </group>
| 	  <group id="AlternateBaseFilter2" label="Base" >
|    		<button id= "AlternateBase2" label = "Alternate" size="large"  							  
| 			  onAction="ShowBaseAlternateUserForm" screentip = "Toggles Alternate Values" imageMso="BlackAndWhiteInverseGrayscale"
| 			  supertip = "Switches Alternate field values between Alernate and Base" /> 
|   	  </group>
| 	  <group id="gInfo2" label="Info" >
|    		<button id= "bInfo2" label = "Info" size="large"  							  
| 			  onAction="ShowInfoForm" screentip = "Information" imageMso="Info"
| 			  supertip = "Show information about this file." /> 
|   	  </group>
|       </tab>
|     </tabs>
|   </ribbon>
| </customUI>

Hopefully this works I saw this in another example here on MrExcel that used the | symbol.
 
Upvote 0
Code: 
|?xml version="1.0" encoding="UTF-8" standalone="yes"?>customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" ******="RibbonControl******">
  |ribbon>
    |tabs>
      |tab id="tBreakdowns" label="Breakdowns">
        |group id="gCustGrp1" label="Breakdowns" >
            |button id="bSummary" size="large" label="Summary" imageMso="BlogHomePage"
                    |screentip = "Summary" onAction="CallSummary" 
			  |supertip = "Displays the Summary information on the Copy Ready Worksheet"/>
		|button id="bFloor" size="large" label="Floor" imageMso="AlignJustify"
                    |screentip = "Floor" onAction="CallFloor" 
			  |supertip = "Displays the Floor information on the Copy Ready Worksheet"/>
 		|button id="bDrawing" size="large" label="Drawing" imageMso="BlogCategories"
			  |screentip = "Drawing" onAction="CallDrawing"
			  |supertip = "Displays the Drawing information on the Copy Ready Worksheet"/>          
		|button id="bZone" size="large" label="Zone" imageMso="AlignJustifyHigh"
                    |screentip = "Zone" onAction="CallZone"
			  |supertip = "Displays the Zone information on the Copy Ready Worksheet"/>                    
        |/group>
	  |group id="gCustGrp2" label="Import Data" tag="AdminGroup" >
            |button id="bChooseImportFile" size="large" label="Choose Import File" imageMso="BlogPublish"
                    |screentip = "Choose the file you need to import"
			  |supertip = "Runs the Choose File macro" onAction="CallChooseFile"/>    
		|button id="bImportData" size="large" label="Import Data" imageMso="CollapseAll"
			  |screentip = "Import Data" onAction="CallImportRawData" 
		  	  |supertip = "Runs the Import Data macro"/> 
		|button id="bHidAndSave" size="large" label="Hide Input Save As" imageMso="FileSave"
			  |screentip = "Hide Input tab and Save As" onAction="CallImportRawData" 
		  	  |supertip = "Runs the Import Data macro"/> 
 	  |/group>	
	  |group id="AlternateBaseFilter" label="Base" >
   		|button id= "AlternateBase" label = "Alternate" size="large"  							  
			  |onAction="ShowBaseAlternateUserForm" screentip = "Toggles Alternate Values" imageMso="BlackAndWhiteInverseGrayscale"
			  |supertip = "Switches Alternate field values between Alernate and Base" /> 
  	  |/group>
	  |group id="gInfo" label="Info" >
   		|button id= "bInfo" label = "Info" size="large"  							  
			  |onAction="ShowInfoForm" screentip = "Information" imageMso="Info"
			  |supertip = "Show information about this file." /> 
  	  |/group>
      |/tab>
      |tab id="tBreakdowns2" label="Breakdowns2">
        |group id="gCustGrp3" label="Breakdowns2" >
            |button id="bSummary2" size="large" label="Summary" imageMso="BlogHomePage"
                    |screentip = "Summary" onAction="CallSummary" 
			  |supertip = "Displays the Summary information on the Copy Ready Worksheet"/>
		|button id="bFloor2" size="large" label="Floor" imageMso="AlignJustify"
                    |screentip = "Floor" onAction="CallFloor" 
			  |supertip = "Displays the Floor information on the Copy Ready Worksheet"/>
 		|button id="bDrawing2" size="large" label="Drawing" imageMso="BlogCategories"
			  |screentip = "Drawing" onAction="CallDrawing"
			  |supertip = "Displays the Drawing information on the Copy Ready Worksheet"/>          
		|button id="bZone2" size="large" label="Zone" imageMso="AlignJustifyHigh"
                    |screentip = "Zone" onAction="CallZone"
			  |supertip = "Displays the Zone information on the Copy Ready Worksheet"/>                    
        |/group>
	  |group id="AlternateBaseFilter2" label="Base" >
   		|button id= "AlternateBase2" label = "Alternate" size="large"  							  
			  |onAction="ShowBaseAlternateUserForm" screentip = "Toggles Alternate Values" imageMso="BlackAndWhiteInverseGrayscale"
			  |supertip = "Switches Alternate field values between Alernate and Base" /> 
  	  |/group>
	  |group id="gInfo2" label="Info" >
   		|button id= "bInfo2" label = "Info" size="large"  							  
			  |onAction="ShowInfoForm" screentip = "Information" imageMso="Info"
			  |supertip = "Show information about this file." /> 
  	  |/group>
      |/tab>
    |/tabs>
  |/ribbon>
|/customUI>

I hope this works this time!
 
Upvote 0
You must log in or register to reply here.

Similar threads

U
  • Question
Excel Ribbon button icon change effect
Replies
3
Views
530
jkpieterse
jkpieterse
B
  • Question
ToggleButton on Ribbon - change ribbon icon
Replies
1
Views
320
BenW71
B
A
  • Question
Custom Ribbon UI <ribbon startFromScratch="true"> not working on MacOS
Replies
0
Views
727
andrevni22
A
T
  • Question
Adding icons to ribbon
Replies
4
Views
150
tiredofit
T
M
  • Solved
Custom Ribbon Button Size in RibbonX
Replies
2
Views
737
mallkins
M

Forum statistics

Threads
1,214,584
Messages
6,120,387
Members
448,956
Latest member
JPav

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top