Because this workbook is opened in 2003 as well. 2003 will not recognize the
2007 Add-In. My 2007 Add-In is only used to make changes to the ribbon when
2007 opens it. I have another add-in with 2003 that is used as a reference
which contains all the code to manipulate the data in the my workbook name
Production Schedule.
So when my Production workbook is opened in 2003 the 2003 Add-In is opened
to be used as a Reference. When 2007 opens my Production workbook in opens
the 2007 Add-In to change the Ribbon and uses 2003 Add-In as a Reference.
Are you asking, becuase you have something else in mind?
--
Cheers,
Ryan
"Ron de Bruin" wrote:
Why do you want to use it is a add-in ?
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"RyanH" wrote in message ...
Thanks for the reply. Since I am using a Add-In workbook is there a way to
hide the custom tab when the workbook I want to use the tab in is deactivated
and then unhide it when the workbook is activated? If not, I will just make
sure to test the workbook I want to use the tab in is the activeworkbook
before any of the buttons execute there code.
--
Cheers,
Ryan
"Ron de Bruin" wrote:
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