Setting focus to ribbon Add-in tab Neil Humphries 11/17/2008 6:08:01 PM I have an auto open macro that creates a custom menu. In 2007, it shows up on the Add-in tab in the ribbon. I would like to set the focus to this tab so that the users will notice it. How do I do this in VBA?

Re: Setting focus to ribbon Add-in tab "Tony Jollans" <My forename at my surname dot com> 11/17/2008 10:50:50 PM This is possible, though hardly straightforward. See http://www.wordarticles.com/Shorts/RibbonVBA/RibbonVBADemo.htm -- Enjoy, Tony www.WordArticles.com "Neil Humphries" <NeilHumphries[ at ]discussions.microsoft.com> wrote in message news:15EB5C8F-1F5D-4430-96D6-4542BCEB0CDF[ at ]microsoft.com... [Quoted Text] >I have an auto open macro that creates a custom menu. In 2007, it shows up >on > the Add-in tab in the ribbon. I would like to set the focus to this tab so > that the users will notice it. How do I do this in VBA?

Re: Setting focus to ribbon Add-in tab Neil Humphries 11/18/2008 2:26:01 PM "hardly straightforward" is an understatement. If all I wanted to do was set the focus to one tab I would work through your code and extract what I need, but I also want to format the menu items. It looks like I need to start learning XML. Thanks for helping to define the effort needed. "Tony Jollans" wrote: [Quoted Text] > This is possible, though hardly straightforward. > > See http://www.wordarticles.com/Shorts/RibbonVBA/RibbonVBADemo.htm > > -- > Enjoy, > Tony > > www.WordArticles.com > > "Neil Humphries" <NeilHumphries[ at ]discussions.microsoft.com> wrote in message > news:15EB5C8F-1F5D-4430-96D6-4542BCEB0CDF[ at ]microsoft.com... > >I have an auto open macro that creates a custom menu. In 2007, it shows up > >on > > the Add-in tab in the ribbon. I would like to set the focus to this tab so > > that the users will notice it. How do I do this in VBA? > >

Re: Setting focus to ribbon Add-in tab "Tony Jollans" <My forename at my surname dot com> 11/18/2008 3:35:12 PM Yes, that is the better way to go. I did the VBA code as an exercise just to see what could be done. -- Enjoy, Tony www.WordArticles.com "Neil Humphries" <NeilHumphries[ at ]discussions.microsoft.com> wrote in message news:1800FC5B-7369-464B-A7CD-58457605304C[ at ]microsoft.com... [Quoted Text] > "hardly straightforward" is an understatement. If all I wanted to do was > set > the focus to one tab I would work through your code and extract what I > need, > but I also want to format the menu items. It looks like I need to start > learning XML. > > Thanks for helping to define the effort needed. > > "Tony Jollans" wrote: > >> This is possible, though hardly straightforward. >> >> See http://www.wordarticles.com/Shorts/RibbonVBA/RibbonVBADemo.htm >> >> -- >> Enjoy, >> Tony >> >> www.WordArticles.com >> >> "Neil Humphries" <NeilHumphries[ at ]discussions.microsoft.com> wrote in >> message >> news:15EB5C8F-1F5D-4430-96D6-4542BCEB0CDF[ at ]microsoft.com... >> >I have an auto open macro that creates a custom menu. In 2007, it shows >> >up >> >on >> > the Add-in tab in the ribbon. I would like to set the focus to this tab >> > so >> > that the users will notice it. How do I do this in VBA? >> >>