merging items from excel 2007 ribbon into classic toolbar

Hi
I wrote an excel add-in for excel 2007. The button that executes my new
add-in reside in a ribbon. I have an old toolbar in my excel 2007 (was create for excel 2003) with the same
menu item name. I want to merge that new toggle button that I created by
using the ribbon into the existing classic menu item. Is it possible?

Regards,

Haim

Haim

It's not possible to merge the controls. You could write commandbar code to the 'old' menu that would appear on the old commandbar on the add-ins tab.

Hi Nick,

Thank you for getting back to me. Can you please give me more information regarding your suggestion. I am pretty new in the excel world (VBA in particular). Do you have an example of how to access the ribbon from VBA and how to add it to an existing menu item.

Kind Regards,

Haim

Haim

i'm obviously not understanding? You have an existing menu created in XL2003. This will appear in XL2007 on the add-in tab. (by default, there is nowhere else it can display).

The ribbon you have created in XL2007 is a seperate object. You cannot merge the two it is one or the other.

If you wanted to replicate the button that is on your ribbon onto the commandbar on the add-ins tab, just go back to Excel 2003, write the extra code and that too will appear on the add-ins tab with the other 'old' controls.