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