Excel 2007 - custom ribbon, display on book open/select?

[MattWPBS]

I'm building a comparison tool in 2007, and I'm using a custom ribbon to for a menu, rather than using space on the sheet for command buttons. This might be a really simple question, but I can't get seem to find a simple answer.

Is there a way in which I can get my ribbon to display when the book is opened, or re-selected? It's making me tear my hair out at the moment.

 

[Krishnakumar]

Hi,

You could look at ExcelFox for some useful examples

 

[MattWPBS]

Hi,

You could look at ExcelFox for some useful examples

No joy I'm afraid. Plenty there about how to customise the ribbon, adding a new tab, etc, but nothing about making sure that the new tab is selected. I don't reallly want to kill every other tab, just make sure that the new one is selected.

 

[S M C]

There's a thread that talks about activating tabs in Excel 2007