Remove closed VBProjects

[XLScottW]

Is there a way to banish VBA Projects from the VBA editor project explorer window?

After the workbooks are closed the VBProject remain even if the VBA window is closed, it only refreshes if Excel is restarted.

Thsi is really frustrating as due to dev work this is creasing a number of instances of ghost projects with the same name as the open file I am working on, is there a way to make the projects close when the workbook is closed?

[Leith Ross]

Hello XLScottW,

In my experience what you are is describing is not typical of the VBE. Once the Workbook is closed the Project Explorer window should reflect this by the VBProject's abscence and update accordingly. You may need to re-install Excel if VBA has become corrupted.

Sincerely,
Leith Ross

[count_ludwig]

I had the same problem and I was able to fix it.
My workbook was held in a public variable.
Closing it was not enough - I had to set the variable to 'Nothing' so that Excel's garbage collector could get rid of it.

Please Login or Register  to view this content.

I've seen this question repeated many times - I might repeat this answer in a few other places. Apologies if it doesn't work for you.