VBAProjects still visible after workbook has closed

R

R Avery

Has anyone ever had the problem that even after you close a workbook,
its VBProject is still visible (and editable - although not savable)?
It is annoying because sometimes I have like 5 VBProjeects open in
addition to all of my add-ins, and the space gets very cluttered.

Also, it is strange.

I can't really give an example on how to reproduce this error, because
it seems to happen randomly. It has nothing to do with reference
problems because even workbooks that I create for a simple task and save
and close within 5 minutes (without ever referencing it at all from
anywhere else), persist in the VBE.

Any help would be appreciated.
 

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

VBAProjects remain in memory after workbook is closed 17
XL2007 .CodeName bug when copying sheet 4
Closed workbooks still appear in VBE? 18
Workbook is viewable in VBE after I close it 2
Check if workbook open (Not working) 3
Macro to copy sheets to another workbook fails after about 45 copi 3
Add-in closes first when Excel is closed, causing problems 1
Phantom workbooks in VBE in Excel 2007 1

Top