customize Excel ribbon
 

Hi, I am new to excel programming and I know this sounds crazy.
I got excel 2003 workbook which use macro to create some custom menu items.
it works fine in excel 2003, but if i open the excel file by using excel
2007, the menu appears under "Add-in" tab. my manager wants to use excel 2003
file to add a tab on excel 2007 ribbon.
Can anyone tell me if this is possible? if it is possible, how can i do it?
is it document level or application level?
Thanks in advance

customize Excel ribbon
 

I believe you're looking at different functionality to do this in Excel 2003
vs. Excel 2007. I believe what you're looking for is how to add a command
bar if you're in Excel 2003? I think the Excel 2007 ribbon functionality
may only work if the file is in a 2007 version (xlsm, xlam, etc.)

Since I'm not exactly sure what you want to do, you may want to poke around
here. It'll give you lots of ideas.

http://www.rondebruin.nl/tips.htm
--
HTH,

Barb Reinhardt



"Joe" wrote:

Hi, I am new to excel programming and I know this sounds crazy.
I got excel 2003 workbook which use macro to create some custom menu items.
it works fine in excel 2003, but if i open the excel file by using excel
2007, the menu appears under "Add-in" tab. my manager wants to use excel 2003
file to add a tab on excel 2007 ribbon.
Can anyone tell me if this is possible? if it is possible, how can i do it?
is it document level or application level?
Thanks in advance