I created a ribbon for one of my Excel files. How do I automatically
have this ribbon selected when this file is opened?

Thanks in advance!
JJ

In Excel 2007, you don't. You can select it in Excel 2010 though.

--

HTH

Bob

"JJ" wrote in message
...
I created a ribbon for one of my Excel files. How do I automatically
have this ribbon selected when this file is opened?

Thanks in advance!
JJ

JJ wrote on 5/27/2010 :
I created a ribbon for one of my Excel files. How do I automatically
have this ribbon selected when this file is opened?

Thanks in advance!
JJ

My understanding of how the ribbon works with indivual workbooks is
that it sets the ribbon to the ActiveWorkbook's XML component. In
practice, switching back and forth between workbooks changes the ribbon
accordingly. (at least, this has been my observation of various open
files with different XML components.

If I misunderstand the way the ribbon works then I invite
enlightenment!

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc