Need help hiding custom toolbar

bobshah2010

New Member
Joined
Nov 29, 2016
Messages
39
Hey guys,

I created custom toolbar using "Custom UI editor for MS office".

Basically i need a macro that once clicked will hide this tool bar. I've attached a sanitized version of what I have so far in the custom UI tool.

I'm not sure what to add to the VBA code. If you could please help it would be much appreciated.

Code:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">	<ribbon>
		<tabs>
			<tab id="customTab" label="tools"  insertAfterMso="TabView" >
					
					<group id="X" label="Information">
					<button id="info" label="Model Info" size="large"  onAction="BMS" imageMso="CreateForm" />
				</group>

Thanks guys!
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>
<tab id="customTab" label="tools" insertAfterMso="TabView" >

<group id="Place" label="Information">
<button id="info" label="Model Info" size="large" onAction="BMS" imageMso="CreateForm" />
</group>
 
Upvote 0
I guess you dont really need to see the XML code. Just let me know what i need to add at the top '<' Tab id '>' layer and i will.
 
Upvote 0

Forum statistics

Threads
1,214,787
Messages
6,121,558
Members
449,038
Latest member
Guest1337

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