Project Explorer: Why do modules/forms for opened workbooks remain visible after 1 workbook was closed?

[Ironman]

Hi

I often have 2 workbooks open at once and then close one of them. At the moment the modules/forms for the closed workbook are still visible in the Project Explorer, which I find annoying.

Is there anything I can amend so that if I close one of the workbooks then the modules/forms for the closed workbook also close in the Project Explorer?

Thanks

 

[Jeffrey Mahoney]

I just tried an example of that and couldn't duplicate it. I have seen that happen once in a blue moon. I attributed it to lack of computer resources (memory and the number of open applications).

 

[Ironman]

Thanks for your suggestion Jeff, although that isn't the case with my own PC, which is pretty highly spec'd.

 

[Jeffrey Mahoney]

Do you have macros running when a workbook is closed?

 

[Ironman]

Do you have macros running when a workbook is closed?

There is a Workbook_BeforeClose macro on the closed workbook but of course that's before the workbook has closed.

 

[Jeffrey Mahoney]

Does this happen when you have only two simple workbooks open?

 

[Ironman]

Yes, just two workbooks. Not sure what you mean by "simple" though? Both workbooks contain a fair amount of code and neither of them are linked to any other workbooks.

 

[Jeffrey Mahoney]

Try it with two workbooks that do not have any code in them at all

 

[Ironman]

The VBA Project for the 2 test workbooks I just created was visible when they were open, then disappeared when I closed them.

 

[Jeffrey Mahoney]

Hypothesis: The problem only occurs in workbooks that have macros that run when the workbook is trying to be closed.

Try commenting out the code in those macro laden workbooks so that no macros run when the workbooks are being closed and do a test to see if the project explored disappears.