| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Workbook Add In with 2007 & 2003, Which Changes Ribbon & Tool
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Workbook Add In with 2007 & 2003, Which Changes Ribbon & Tool
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving from 2007 to 2003 - 2003 won't open the file | Excel Discussion (Misc queries) | |||
| ribbon into tool bard and drop down menus | Excel Discussion (Misc queries) | |||
| 2007 & 2003 - Default open with 2003 | Excel Discussion (Misc queries) | |||
| In 2007 Add new Tool button to keep custom macros for Workbook | Excel Discussion (Misc queries) | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Hybrid Mode
