Default Ribbon on File Open

J

JJ

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
 
G

GS

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
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default entry in dropdown on Ribbon 1
Problem in adding macro to ribbon through Add-in 7
How to execute macro when selecting user-defined menu in ribbon 6
Excel 2007 | Add-Ins Ribbon 1
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Hide Ribbon In XLS Workbook When Using Excel 2007 12
Print Preview Ribbon 3
Expand/collapse toolbar ribbon 6

Top