How to do this is "beyond the scope of a newsgroup post" I'm afraid. And I
don't have time to do a full-blown example. Can you do as you suggested
before - have the called macro make sure the right workbook is active?
--
Jim
|I am very new to XML and afraid I don't know much about it. How would I
| change the tabs visiblity attribute when the workbook is activated and
| deactivated.
| --
| Cheers,
| Ryan
|
|
| "Jim Rech" wrote:
|
| > >>How can I ensure that the tab is always placed last in the Ribbon.
| > >><tab id="MyCustomTab" label="My Tab" insertAfterMso="TabDeveloper">
| >
| > If you leave the insertAfterMso="TabDeveloper" out completely I believe
| > Excel will place your group last at the time it adds the group. The
above
| > places the group between the Developer tab but before Add-ins if you
have
| > that displayed. I say "at the time it adds the group" because a later
| > loaded workbook or add-in can have its group placed after yours so you
| > cannot force your to always be last.
| >
| > Re changing the tab's visibility at runtime, you should be able to do
that
| > by invalidating the ribbon with the workbook activate and deactivate
events
| > along with using the getVisible attribute to name a procedure returning
the
| > visible state.
| >
| > --
| > Jim
| > | > |
| > | Hi Ryan
| > |
| > | Use insertAfterMso
| > |
| > | <tab id="MyCustomTab" label="My Tab" insertAfterMso="TabDeveloper">
| > |
| > |
| > | > Plus, I have noticed that if I save the workbook with a .xls
extension
| > the
| > | > Ribbon goes back to default settings when activating another
workbook
| > and
| > | > back to the custom settings I have when the my workbook is
reactivated.
| > Why
| > | > does it not do that when I have the workbook saved with a .xla
| > extension?
| > |
| > | That's normal in 2007
| > | A xla is a hidden workbook and the code/menus that is in it you want
to
| > use in all
| > | open workbooks that is in the xla.
| > |
| > | In a normal workbook it will load the ribbonX when you activate the
| > workbook and
| > | remove your changes when you deactivate it
| > |
| > |
| > |
| > | --
| > |
| > | Regards Ron de Bruin
| > |
http://www.rondebruin.nl/tips.htm
| > |
| > |
| > | > | >I have a 2007 Add-In workbook that has XML in it to add a Custon Menu
Tab
| > in
| > | > the Ribbon. How can I ensure that the tab is always placed last in
the
| > | > Ribbon. For example, Home, Insert, Page Layout, ...., Developer,
CUSTOM
| > TAB
| > | > HERE.
| > | >
| > | > Plus, I have noticed that if I save the workbook with a .xls
extension
| > the
| > | > Ribbon goes back to default settings when activating another
workbook
| > and
| > | > back to the custom settings I have when the my workbook is
reactivated.
| > Why
| > | > does it not do that when I have the workbook saved with a .xla
| > extension?
| > | > --
| > | > Cheers,
| > | > Ryan
| >
| >