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

2012-06-12 Thread Rajan_Verma
: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

2012-06-12 Thread Divaker Pandey
*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, Apr 2, 2012 at 2

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

2012-03-30 Thread Divaker Pandey
Please help, On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey divake...@gmail.com 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 darwin.chankaw...@gmail.comwrote: Hi

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

2012-03-30 Thread ashish koul
check this http://www.rondebruin.nl/ribbon.htm#Examples On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey divake...@gmail.comwrote: Please help, On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey divake...@gmail.comwrote: thanks for reply noorain But I want as in attached snapshot.

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

2012-03-30 Thread Sam Mathai Chacko
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 koul.ash...@gmail.com wrote: check this http://www.rondebruin.nl/ribbon.htm#Examples On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey

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

2012-03-29 Thread Divaker Pandey
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 darwin.chankaw...@gmail.comwrote: Hi Noorain, Regarding the code provided from above, do the custom control button and tab include all

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

2012-03-28 Thread NOORAIN ANSARI
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

2012-03-28 Thread Darwin Chan
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