Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

Dear Divakar, Please use below code to add custom button and Tab Option Explicit 'Add a new menu to Worksheet Menu Bar Public Sub AddCustomMenu() Dim cbr As CommandBar Dim ctlMenu As CommandBarControl 'Add new menu control Set cbr = Application.CommandBars("Worksheet Menu Bar")

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

Hi Noorain, Regarding the code provided from above, do the custom control button and tab include all operations too? For example, the sorting button, the operations include in the following code? I would like to learn more from this. .Caption = "Sort Names Descending" .On

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

thanks for reply noorain But I want as in attached snapshot. Custom Menu hope you will help soon. Divaker On Thu, Mar 29, 2012 at 9:33 AM, Darwin Chan wrote: > Hi Noorain, > > Regarding the code provided from above, do the custom control button and > tab include all operations too? > > For

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

Please help, On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey wrote: > thanks for reply noorain > > But I want as in attached snapshot. Custom Menu > > hope you will help soon. > > Divaker > > > > > > > On Thu, Mar 29, 2012 at 9:33 AM, Darwin Chan > wrote: > >> Hi Noorain, >> >> Regarding the co

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

check this http://www.rondebruin.nl/ribbon.htm#Examples On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey wrote: > Please help, > > > On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey wrote: > >> thanks for reply noorain >> >> But I want as in attached snapshot. Custom Menu >> >> hope you will

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

Try this http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/ Regards, Sam Mathai Chacko On Fri, Mar 30, 2012 at 9:37 PM, ashish koul wrote: > check this http://www.rondebruin.nl/ribbon.htm#Examples > > > > > > > On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey wrote: > >> Pleas

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

Hi Expert, One more question if, i want to select my Custom Menu tab on each time workbook window activation, how i can i do it. Divaker On Mon, Apr 2, 2012 at 2:18 PM, Divaker Pandey wrote: > Dear Ashish, > > Thanks from my bottom of hearts. > > I salute you. > > Divaker > > > On Fri, Mar 30,

RE: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

:03 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in Hi Expert, One more question if, i want to select my Custom Menu tab on each time workbook window activation, how i can i do it. Divaker On Mon

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ want to add our own custom button and Tab > in Excel 2007 name in place of add-in > > ** ** > > Hi Expert, > > One more question if, i want to select my Custom Menu tab on each time > workbook wind

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

8100659 [IM-Gtalk]* >>> >>> ** ** >>> >>> *From:* excel-macros@googlegroups.com [mailto: >>> excel-macros@googlegroups.com] *On Behalf Of *Divaker Pandey >>> *Sent:* 12 June 2012 3:03 >>> *To:* excel-macros@googlegroups.com >>> *Sub