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

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

Hi Ron and thanks for posting on this. Your answer makes sense and I can see
how MS might even want that to happen although I would prefer to not have my
UI affected just because the file I have active changes. Do you expect this
is something I will have to live with or might there be a way around this?

Jeff


"Ron de Bruin" wrote:

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

Why do you want to edit (and what) the add-in and want to see your menu ?



--

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


"JeffreyW" wrote in message ...
Hi Ron and thanks for posting on this. Your answer makes sense and I can see
how MS might even want that to happen although I would prefer to not have my
UI affected just because the file I have active changes. Do you expect this
is something I will have to live with or might there be a way around this?

Jeff


"Ron de Bruin" wrote:

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

Well, I have assembled a set of tools on this custom tab that may be useful
in working with either the Add-in itself or with other open Excel files that
my attention may be diverted to from time to time and I'd like for all of
these tools to stay where I put them without MS deciding that I don't need
them anymore.

Jeff


"Ron de Bruin" wrote:

Why do you want to edit (and what) the add-in and want to see your menu ?



--

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

Use a seperate add-in with the tools then

--

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


"JeffreyW" wrote in message ...
Well, I have assembled a set of tools on this custom tab that may be useful
in working with either the Add-in itself or with other open Excel files that
my attention may be diverted to from time to time and I'd like for all of
these tools to stay where I put them without MS deciding that I don't need
them anymore.

Jeff


"Ron de Bruin" wrote:

Why do you want to edit (and what) the add-in and want to see your menu ?



--

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