Hello,

I have created a .xlam file to create a menu in Excel 2007 using XML. The menu has come successfully along with controls, buttons, comboBox, etc. User will create many workbooks and navigates from one workbook to another and within one cell to another frequently. Irrespective of user's navigation, I want styles of activeworkbook to be displayed in the comboBox created in ribbon.

1. When the user navigates from one cell to another, the comboBox on ribbon should display Activecell's style.
2. When the user clicks the comboBox on ribbon, it should display all styles from Activeworkbook.
3. If the user clicks any item in the comboBox on ribbon, then activecell's style should be changed with the item's name.

This comboBox should look like in-built Font and FontSize comboBoxes.
I have added Font using <gallery idMso="Font"/>
I have added FontSize using <gallery idMso="FontSize"/>

If I add style gallery using <gallery idMso="StyleGalleryClassic"/>, then the user cannot see activecell's style until the user clicks the Style gallery.

Can you help me to solve this issue.

Regards,

Srinivas