Re: Closed workbooks still appear in VBE?

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm not sure the COM add-in needs to be installed in or visible to Excel, or
even that it has to be a COM add-in. It was that way for my computer, and
removing the add-in made the problem go away, so I surmise the add-in caused
the problem. That may not even be true.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"robotman" <robotman@xxxxxxxxx> wrote in message
news:1181668027.810868.263680@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Dave,

I didn't realize I had to choose the "Tools" category under the
Command Tab. I now see where the "COM Add-ins" is.

I added the button and there are no COM add-in's available. So I'm
back to square one.

Any other ideas what can be causing the phantom workbooks? It is a
strange problem. I'm still suspicious of this other complex charting
macro that I run. Even though it's not loaded when I start Excel, is
there any way it left behind some residual code or setting that is
causing the problem?

Thanks.

John



.

Quantcast