In the RibbonX this will add a button for example

<button id="customButton1" label="Caption 1" size="normal" onAction="Macro1" imageMso="DirectRepliesTo" /

When you click the button it run the macro "Macro1"

This looks like this in a standard module of your workbook

Sub Macro1(control as IRibbonControl)

End Sub

And not like this

Sub Macro1()

End Sub

Is this your problem ?



--

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


"shantanu" wrote in message ...
On Dec 16, 9:07 pm, "Ron de Bruin" wrote:
Hishantanu

Start herehttp://www.rondebruin.nl/ribbon.htm

Or this one (easy)http://www.rondebruin.nl/qat.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"shantanu" wrote in ...
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- Hide quoted text -

- Show quoted text -

Hello
Thanks for the awesoem examples, but i am yet not able to get what i
require. After going thru the steps of converting the existing 2003
excel macro to xlsm fine and adding the customUI, i am able to create
a new tab but i am unable to connect the VBA code and the logic with
the menu. Please help

Regards
Shantanu