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")
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
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
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
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
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
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,
: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
:* 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
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
10 matches
Mail list logo