Code doesn't disappear

[Otto Moehrbach]

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

[Susan]

as far as i am aware, the VBE doesn't get cleared until excel gets
completely closed out. therefore, whatever documents you open in a
session of excel remain in the VBE until you close excel.
:)
susan

On Mar 24, 2:30 pm, "Otto Moehrbach" <moehrbachoex...@bellsouth.net>
wrote:

[Susan]

well, now, i may be completely wrong on that.
it doesn't work that way on my machine (at the moment) although i know
i have seen lingering documents in the VBE before..........
susan

> > Is this normal?  Thanks for your time.  Otto- Hide quoted text -
>
> - Show quoted text -

[Tim Zych]

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" <moehrba...@bellsouth.net> wrote in message
news:%2377Ql6K...@TK2MSFTNGP03.phx.gbl...