Default Ribbon on File Open
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 |
Default Ribbon on File Open
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 |
Default Ribbon on File Open
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 |
All times are GMT +1. The time now is 09:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com