Hi JeffreyW

If IsAddin = false Excel see it as a normal workbook so it will read
the RibbonX when you activate the workbook and remove the custom tab
when you deactivate the workbook

So it is normal what you see


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JeffreyW" wrote in message ...
I have a custom Excel 2007 Tab, deployed in an XLAM add-in file that works as
it is supposed to in other regards, but disappears when editing the XLAM file
itself (i.e., the ThisWorkbook IsAddin property is changed to False) AND then
Switching Windows to another Excel file. If I switch back to the XLAM file,
the custom Tab re-appears but then disappears again when I switch back to
another file besides the XLAM. When the XLAM ThisWorkbook IsAddin property
is changed back to True, the custom Tab is then again visible even with the
same file that it was previously not visible with when editing the XLAM
file.

I'm hoping someone might either have some insights into to either how to
prevent this from happening or perhaps suggest a macro to correct it if it
can't be prevented.

Thanks!

Jeff