: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
*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
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
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.
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
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
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