I have created custom menu tab, but if i have open two workbook and switch one to another, then i want to activate customtab menu, when i switch on applicationworkbook. this time it always goto Home tab
Divaker On Tue, Jun 12, 2012 at 6:25 PM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote: > Dear Divakar, > > Please see Ashish Koul created My Menu Add-In. > I think your need to create this type of custom Menu. > > Please check and revert. > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > On Tue, Jun 12, 2012 at 5:55 PM, Divaker Pandey <divake...@gmail.com>wrote: > >> Thanks for reply ranjan, but i want that whenever i activate workbook >> that contains customtab, it must selected by detault. >> >> >> On Tue, Jun 12, 2012 at 5:52 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote: >> >>> You can read about CustomUI Editor , it basically used to manipulate and >>> create new ribbon in Excel 2007 and later**** >>> >>> ** ** >>> >>> * * >>> >>> *Regards* >>> >>> *Rajan verma* >>> >>> *+91 7838100659 [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 >>> *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:18 PM, Divaker Pandey <divake...@gmail.com> >>> wrote:**** >>> >>> Dear Ashish, >>> >>> Thanks from my bottom of hearts. >>> >>> I salute you. >>> >>> Divaker**** >>> >>> ** ** >>> >>> On Fri, Mar 30, 2012 at 11:30 PM, Sam Mathai Chacko <samde...@gmail.com> >>> wrote:**** >>> >>> 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 <divake...@gmail.com> >>> wrote:**** >>> >>> 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.com> wrote:**** >>> >>> 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" >>> .OnAction = "SortList" >>> .Parameter = "Dsc" **** >>> >>> ** ** >>> >>> ** ** >>> >>> ** ** >>> >>> 2012/3/29 NOORAIN ANSARI <noorain.ans...@gmail.com>**** >>> >>> See attached add-in's coding for reference**** >>> >>> On Wed, Mar 28, 2012 at 9:22 PM, Divaker Pandey <divake...@gmail.com> >>> wrote:**** >>> >>> >>> Hi Expert, >>> >>> I want to add our own custom button and Tab in Excel 2007 name in place >>> add-in. >>> >>> Divaker**** >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com**** >>> >>> >>> >>> **** >>> >>> >>> -- **** >>> >>> Thanks & regards,**** >>> >>> Noorain Ansari**** >>> >>> *http://noorainansari.com/***** >>> >>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >>> **** >>> >>> **** >>> >>> ** ** >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com**** >>> >>> >>> >>> **** >>> >>> ** ** >>> >>> -- **** >>> >>> Best Regards,**** >>> >>> Darwin Chan**** >>> >>> darwin.chankaw...@gmail.com**** >>> >>> kw42c...@yahoo.com.hk**** >>> >>> ** ** >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com**** >>> >>> ** ** >>> >>> ** ** >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com**** >>> >>> >>> >>> **** >>> >>> ** ** >>> >>> -- **** >>> >>> *Regards***** >>> >>> * ***** >>> >>> *Ashish Koul***** >>> >>> *http://www.excelvbamacros.com/***** >>> >>> *http://www.accessvbamacros.com/* <http://www.accessvbamacros.com/> **** >>> >>> **** >>> >>> P Before printing, think about the environment.**** >>> >>> **** >>> >>> ** ** >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com**** >>> >>> >>> >>> **** >>> >>> -- >>> Sam Mathai Chacko**** >>> >>> ** ** >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com**** >>> >>> ** ** >>> >>> ** ** >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com**** >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
