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?

You may want to share the mysterious workbook's name and its project name.

But a workbook can have a reference to another workbook -- each time you open
the "real" workbook, excel will open any workbook that is "referred to" by that
original workbook.

Open your workbook
Go to the VBE
Select your workbook's project
Tools|References

Look at the items that are checked. Do you see that mysterious workbook's
project?

If yes, you can uncheck it.

But ....

The developer may have set that reference on purpose. Maybe he/she wanted to
get data from a worksheet in that workbook--or use any of the functions that
were stored in that workbook.

wrote:

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?

--

Dave Peterson

Ps. You may want to search google for that mysterious workbook name/project
name. Maybe it'll be quicker and you'll have a reason why it should be kept (or
removed).

wrote:

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?

--

Dave Peterson

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?

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?