VBA project remain open in VBA Editor when I close the workbook

When I close an Excel 2010 workbook without closing the Excel application the correspondent VBA project remain open in VBA Editor. I have to close Excel application to get rid of that problem.

 

The macros are not password protected, and I have the same problem with every workbook and every macro.

I tried to disable all the add-ins but the problem persists.

I reinstalled Office 2010 and also tried repairing Office but this not fixed the issue.

In 2003 version I didn't have this problem.

I don't have the same issue with the other Office applications.

October 8th, 2010 10:50am

Hello Petra,

Excel works differently than other Office applications as the VBA window is associated with the appilcation and not the particular workbook that it was launched from.  As you have experienced, you can reproduce the issue with a clean install of Excel 2003, 2007, or 2010 and having no add-ins installed via the following:
1) Open blank Excel workbook
2) Press Alt+F11 to launch the VBA editor window
3) Close the Excel workbook(little 'x')
*Result: The VBA Editor window remains open

If you are seeing seeing VBA projects in the left hand 'Project Explorer' pane and have no workbooks open, you are most likely seeing Projects and Modules of add-ins or hidden workbooks.

If I'm missing the mark here, please list out the steps you are using to reproduce the issue along with the actual vs expected results.

Best Regards,
Chad

Free Windows Admin Tool Kit Click here and download it now
October 12th, 2010 9:18pm

Chad,

You may well have answered the query that Petra had, but I read the query slightly differently and it matches an error I've been having.  In my case if I open an excel workbook with a VBA project and then subsequently close that workbook (but keeping excel open) then the left hand side of the vba project will still hold the info and modules for the now closed workbook.  ie it's not just add-ins and hidden workbooks that are seen here.

If I expand the folders under this VBAproject and double click "thisworkbook" then the info in the properties window is blank which I guess makes sense given the workbook is closed, nevertheless I can still expand and view the modules and all code within them.

I've only just started using Excel2007 (not 2010 as in the inital query) and this has started to happen, but when using excel 2003 these issues do not occur.  In some ways I'm unconcerned, however this does seem to hog a bit of memory and sometime excel now runs out of memory and I have to crash out.  I'm unsure if both these issues are linked however.

Any help or advice that you have would be appreciated (or from any other posters who have seen this issue.)

Regards

 

Irfon


I may well have found an answer to this now here http://www.dailydoseofexcel.com/archives/2004/12/11/google-desktop/  Google desktop wasn't the issue but another program which must also use some .net code.
  • Edited by Irfon Tuesday, March 22, 2011 10:51 PM Fix
March 22nd, 2011 10:27pm

Hi All,

Is there any new solution on this issue?

I have the same issue with excel 2007, but I don't have google drive installed on my desktop and I have not installed any add-in neither.

When I open 2 excel workbooks and their vba, both vba project remain open when I closed one of them.

Thank you,

Ben

Free Windows Admin Tool Kit Click here and download it now
July 19th, 2015 10:22pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics