customize Excel ribbon

J

Joe

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
 
B

Barb Reinhardt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Ribbon 5
excel 2010 classic look no ribbon 3
Excel 2007 | Add-Ins Ribbon 1
Toolbars in Excel 2007 6
Hide Ribbon In XLS Workbook When Using Excel 2007 12
New Menu tab in Excel 2007 7
Add custom button to existing group Excel 2007 3
Problem in adding macro to ribbon through Add-in 7

Top