Custom Ribbon - Reproducing Font & Fill Color Galleries, Losing Split Feature

[MPC]

I'm customizing my Excel 2007 ribbon with the Custom UI editor that is commonly available. My end result is a custom tab with my own layout of normal excel actions and custom macros. Two of the excel items I want to retain are Font Color and Cell Fill Color. I include them in my XML code as:

gallery idMso="FontColorPicker" 
gallery idMso="CellFillColorPicker"<gallery idmso="CellFillColorPicker"><gallery idmso="FontColorPicker"><gallery idmso="CellFillColorPicker"><gallery idmso="FontColorPicker">

</gallery></gallery></gallery></gallery>
<gallery idmso="CellFillColorPicker"><gallery idmso="FontColorPicker"><gallery idmso="CellFillColorPicker"><gallery idmso="FontColorPicker">They show up in my ribbon as expected, but when clicked, they will only activate the underlying gallery, regardless of where on the button they are clicked. In the normal ribbon, these buttons are split into left (click to apply most recent color) and right (access dropdown gallery).

All other instances of me using built-in excel controls in my custom tab work out fine. The buttons/menus/etc come though and behave normally. Is there any modification I can make to my code that will grant my two color galleries their full functionality?</gallery></gallery></gallery></gallery>

 

[RoryA]

If memory serves (don't have Excel here) you need a buttonGroup enclosing each gallery control.

 

[DragonWood]

MPC,

Here, try this it has helped me a lot.

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

 

[hefting]

MPC - did you ever find a solution to this problem? I am having the same problem and pretty desperate to solve it

 

[Chris Macro]

I was having the same problem but was able to use Ribbon Commander to help solve this issue. In order to get the split button functionality to work with either the paint bucket (cell fill color) or Font Color Picker, you need to change the word gallery to control. So for example your xml code might look like this:

<control idMso="CellFillColorPicker"/>
<control idMso="FontColorPicker"/>

The steps I took in Ribbon Commander were as follows:

1. Goto RC addin manager
2. Load the 'Dynamic Command Search' addin
3. Search for 'cellfill'
4. Click Export XML to CSV

Hope that helps!

 

[MPC]

Chris-

Thanks, it looks like it works.

 

[MPC]

MPC - did you ever find a solution to this problem? I am having the same problem and pretty desperate to solve it

See the suggested fix from Chris Macro. Years later and it was as simple as one word changing.

 

[Chris Macro]

Better late then never

 

[adim1973]

God bless you for this tip, it helped me a lot!

I was having the same problem but was able to use Ribbon Commander to help solve this issue. In order to get the split button functionality to work with either the paint bucket (cell fill color) or Font Color Picker, you need to change the word gallery to control. So for example your xml code might look like this:

<control idmso="CellFillColorPicker">
<control idmso="FontColorPicker">

The steps I took in Ribbon Commander were as follows:

1. Goto RC addin manager
2. Load the 'Dynamic Command Search' addin
3. Search for 'cellfill'
4. Click Export XML to CSV

Hope that helps!

</control></control>