VBA Project and Modules Remain in Project Explorer after workbook closed

In Excel 2010 with SP1, when I close an Excel file that contains a VBA project, the project for that file remains in the VBA project explorer. It happens for every file I have with, or without, a VBA project. If I open a new file (Book1), and close it. Then open a new file (Book2). Then go to the VB editor, I'll see both Book1 and Book2 in project explorer. The only way to clear the project explorer is to close Excel entirely. This is a new development. A week ago, it wasn't happening. I know of no changes in my environment.

Any insight would be appreciated.

Hi avr5iron,

This is strange.
I checked my Excel 2010 and after closing book1, 2 etc, they also get closed from VB project explorer. An option could be to un-install and then re-install the Office pack.

I am making myself an interested party here and would like to know the solution, if any comes up. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

I've noticed this occassionally but not sure why it happens

I close an Excel file

It looks as if the file is only hidden, not closed.

You can check:

Please Login or Register  to view this content.

Open Excel in Safe mode (hold down Ctrl key while opening normally, and answer Yes to the prompt - you should see Safe Mode in the title bar). Does the problem still occur?

Interesting - I have only ever seen/heard of this being caused by COM addins.
Just to check, you did see 'Safe Mode' in the title bar? (and it was the only instance of Excel you had open?)

I don't think my work would approve of that!

Can you check your Control Panel and see what updates have been applied recently, or new programs installed.

You can post a screen dump. you already did

OK, so you have installed a whole raft of updates there! Do you have the Visual Studio Design Time adaptor COM addin installed in Excel?

Do you know more precisely when the issue started then?

You can check if some files have been converted to addins:

Please Login or Register  to view this content.

So we can can exclude that.

Can you post a screendump of the VBEditor project explorer window ?

Can you try uninstalling the Google toolbar from Internet Explorer? (Google's Desktop search used to cause this problem, so...)

With a reboot?

How about if you run Windows in Safe Mode?