Default Ribbon on File Open
in [Programming]
|
Prev: Array - retrieve certain amount of recods for query
Next: Macro for hiding all rows accept those selected by a dated column?
From: JJ on 27 May 2010 19:26 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
From: Bob Phillips on 28 May 2010 05:16 In Excel 2007, you don't. You can select it in Excel 2010 though. -- HTH Bob "JJ" <metaldogo70(a)gmail.com> wrote in message news:35e2c230-9f95-47dc-83e2-be5c890316f7(a)v12g2000prb.googlegroups.com... >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
From: GS on 28 May 2010 12:22
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 |