I am also facing the same problem. When I close the workbook by
Fileclose (not by VBA), workbook closes but the VBA project explorer
still shows the same. VBA also opens the project contained in closed
workbook if I double click on it in VBA. I hope to solve the proble
with the help of experts here.
Regards,

John B wrote:
I have a sub that opens several workbooks (with macros embedded).
at the end of the sub I have

workbooks("book1.xls").close true ' to close all but 1 workbook

the workbooks are closed but if I open vba window, I can still see the vba
projects.

if I do debug.print workbooks(2).name I get out of range error -- which i
assume the object no longer exists ...

how can i truely close workbooks?

application.quit?

I want to close all but 1 workbook.