Custom UI - Default color picker

[Jaye Cavallo]

I have created a custom tab for my Excel file. Would someone be able to guide me through the process of adding to my custom tab Excel's default color picker, the icon on the home tab with a paint bucket icon that drops down with the theme colors, standard colors, recently used colors, no fill, and more colors?

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">

<!-- <commands> -->
<!-- Disable Save As in the Backstage(File)menu in 2010 -->
<!-- <command idMso="FileSaveAs" enabled = "false" /> -->
<!-- </commands> -->

<ribbon>
<tabs>
<tab id="MyCustomTab" label="Outreach" insertBeforeMso="TabHome">

<!-- Group for Shading -->

<group id="group1" label="FillColor">

<button id="FillColor1" label="Fill Yellow" onAction="Callback"
imageMso="ShadingPicker"
screentip="Fill Selected Cells with Yellow"
/>

<button id="FillColor2" label="Fill Green" onAction="Callback2"
imageMso="ShadingPicker"
screentip="Fill Selected Cells with Green"
/>

<button id="FillColor3" label="Fill Blue" onAction="Callback3"
imageMso="ShadingPicker"
screentip="Fill Selected Cells with Blue"
/>

<button id="FillColor4" label="No Fill" size="large" onAction="Callback4"
imageMso="ShadingPicker"
screentip="Remove Fill Color"
/>

</group>
</tab>
</tabs>
</ribbon>
</customUI>

 

[Domenic]

First we'll need to find the control's ID. Therefore, let's first display the dialog box for customizing the ribbon...

Ribbon >> File >> Options >> Customize Ribbon

Now you'll see the following dialog box...

Then, move your cursor over Fill Color in the Popular Commands window on the left. Then you'll see the control's ID displayed, which in this case is CellFillColorPicker...

Now that we know the control's ID, the following line can be added to your code...

<control idMso="CellFillColorPicker" />

Hope this helps!