More.....The workbook is what I consider a masterworkbook. Basically
all my macros are in master .xls workbooks which I Save As .xla. Thus
I can control versions of the addins this way. The phantom workbook is
displaying in the VBA editor in my master .XLS document as a XLS
document.. The phantom workbook name is one of the workbooks which I
had open while working in my masterworkbook.

In Tools- references workbook shows up UNCHECKED as UNSAVED document
but the dang thing still opens when I open my masterworkbook.

Also, if I try to export any of the phantom workbook objects such as
sheets, etc, I get an I/O error.




Jon Peltier wrote:
The mysterious workbook isn't the add-in workbook itself, is it? Though it
should display its properties in the properties pane.

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


wrote in message
oups.com...
I have a workbook which I save as an addin. Problem is that there is a
mysterious workbook which attaches itself to my primary workbook and it
only displays in the VBA editor. The problem is that this workbook is
not viewable while in Excel. In addition, while in the VBA editor, if
you click on any of the objects of the hidden workbook in the VBA
editor, it as no properties, there are no options to delete or remove.
It doesn't show up on the LINKS MENU in Excel either. Does anyone know
how to remove this phantom workbook?