View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Adding Menus to the Ribbon


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