Lost post Re VBE

O

Otto Moehrbach

I posted this query about 5 days ago and it never appeared in my OE listing
of posts so I don't know if I got a reply.

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
 
J

JLGWhiz

I did not see your old posting, but I do not believe it is common for the
code of a closed workbook to appear in the VBE. Check your status bar to be
sure that the workbook name no longer appears there and is infact closed
rather than just minimized.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code doesn't disappear 4
Refer to a lone sheet 5
User Created Menu 3
Assigned macro change 5
Odd behavior 4
(Cross Post) 2
Workbook.Open fail in 2003, good in XP 14
Passing a value across workbooks 1

Top