Actually, Excel 2007 have many changing (lets said that is improvment),
and the new menu bar in Excel 2007 (we call Ribbon) are using XML to create
so, if you want to create new 2007 menu start-alone (instead of add-in menu),
you need to save the excel to .xlsm and then open with a un-zip program,
and then, you need to change some of those file.

i give you a web-site for some guide-line
http://www.xtremevbtalk.com/showthread.php?t=265636


"shantanu" wrote:

Hello

I have migrated to excel 2007 from excel 2003.I have few macros which
when executed create a new tab in excel menu . Now when i run the
same
in excel 2007 the macros are seen under Add-In menu in ribbon. Is it
possible to get it on the main menu.


Thanks in advance
Shantanu