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
"RyanH" wrote in message ...
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