I believe this is normal as A.xls is still in memory.

This is replicable:

1. Create a workbook called A.xls. Add a module with some code.

2. Create a 2nd workbook, add a module and run the following macro:

Public wkb As Workbook
Sub Test()
Set wkb = Workbooks("A.xls")
End Sub

3. Close A.xls

4. Go back to the VBE and A.xls is still there and the code is visible too.

5. Click the Stop button. A.xls is cleared out.

Now perform the steps again with a modified macro, and omit Step 5.

Sub Test()
Set wkb = Workbooks("A.xls")
Set wkb = Nothing
End Sub

A.xls is no longer available.


--
Tim Zych
http://www.higherdata.com
Workbook Compare - Excel data comparison utility
Free and Pro versions

"Otto Moehrbach" wrote in message
...
Excel XP & Win XP
I've never seen this before but I can't say it has never happened
before.
I have wb A.xls open and I work in the VBE.
I get finished and CLOSE THE WB but leave Excel running.
I go into the VBE and, behold, there is wb A.xls listed.
I click on wb A.xls and there is the code for that wb. All of it.
Remember that wb A.xls is closed.
Is this normal? Thanks for your time. Otto