hi RyanH

See this page
http://www.rondebruin.nl/compatiblemenu.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"RyanH" wrote in message ...
I have a workbook that is currently 7 megs and filled with userforms and
macros. I want to create an Add In workbook that will hold all the code and
the current workbook will just hold the data and make references to the Add
In. The problem is this, depending on which version of Excel opens the data
workbook I want this Add In to change the Ribbon in 2007 or change the
CommandBars in 2003 of the data workbook when it is opened.

Do I need to develop two different Add-Ins, one for 2003 & one for 2007?

I have already used the Custom UI to use XML to change the Ribon of a
workbook. If I made this workbook an Add In, how could I make the Add In XML
change the data workbook Ribbon?
--
Cheers,
Ryan