Activate ciustom tab when opening a workbook

[Eric Rossiter]

Hi,

Is it possible to activate a particular custom tab when a workbook is open

i.e I have a workbook called time sheets. I have a custom ribbon called "Time Sheets"

Initial opening of Excel with time sheets work book has the home tab activated

Opening Time Sheets while another workbook is open activates whatever tab was open at the time

It would be nice when opening Time Sheets that the ribbon associated with bit opens too

Thanks

Eric

 

[Greg Truby]

AFAIK, the only way to do it is a bit complex. However, you state that you have already developed a workbook with a custom tab. Is this a tab that is included in the XML of the workbook and you created it using the CustomUI editor or some other tool? Or is the tab the result of Ribbon customization in the user interface using Excel 2010?

 

[repairman615]

Hello,

Have a look here:
http://www.excelguru.ca/blog/2008/08/13/activating-a-tab-on-the-ribbon/

 

[Greg Truby]

Hello,

Have a look here:
http://www.excelguru.ca/blog/2008/08/13/activating-a-tab-on-the-ribbon/

Hmmm, I'm surprised Ken is recommending the SendKeys route. I would have used a callback and a WITHEVENTS copy of the app object, trapping wb activate events.
However Ken knows way more about the Ribbon than I and if he's saying that SendKeys is the way to go, that's what I'd do.

 

[Eric Rossiter]

Thank you all,

Worked a treat in Excel, but cant seem to get it to work in Word.

If I use an Autpen the same as I did in Excel. Where should the code live?

It never ceases to amaze me at the speed that I get replies to my questions. You really are a great bunch of people

Cheers

Eric

 

[Greg Truby]

Thank you all,

Worked a treat in Excel, but cant seem to get it to work in Word.

If I use an Autpen the same as I did in Excel. Where should the code live?

It never ceases to amaze me at the speed that I get replies to my questions. You really are a great bunch of people

Cheers

Eric

Yup, we were lightening fast right up until you asked a Word question. And no, no ideas whatsoever on how to program Word.

 

[RoryA]

SendKeys is unnecessary when you have the Accessibility objects - see Tony's excellent work here. (just so happens to be in Word too! Works with any Ribbon app though)

 

[Eric Rossiter]

Hi Rorya,

I looked at the article you linked, but the was no link to the example

Cheers

Eric

 

[RoryA]

The link is at the end of the 'downloadable sample' section.

 

[Greg Truby]

Eric, I didn't see the link either - I was using IE9. After seeing Rory's response, I tried viewing that webpage in FireFox and Chrome and the link shows up in both of those browsers. But for some reason, it doesn't display the download links properly in IE.