PDA

View Full Version : [SOLVED:] Shapes Panel (not just button)



RayKay
01-16-2019, 07:49 AM
Hi John and everyone

On the default Home ribbon there's a shapes panel, that reveals many shapes - but when I use that tool when customizing a ribbon it becomes just a button (not wide panel of shapes).

Is there any VBA so I can add this shapes panel to a ribbon? Maybe make it 4 buttons wide?

Thank you.

John Wilson
01-17-2019, 03:37 AM
You don't use vba to add to the ribbon you need to code in XML

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon >
<tabs >
<tab id="NewTab1" label="Johns Tab" insertAfterMso="TabHome">
<group id="NewGrp1" label="Shapes" >
<control idMso="ShapesInsertGallery" size="large"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>
23572