View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] robotman@gmail.com is offline
external usenet poster
 
Posts: 73
Default Workbooks still appear in Project Explorer after closing in Excel?

I'm having a weird problem when my workbooks still show up in the VBA
Project Explorer even after I've closed them in Excel.

Sometimes if I open the same workbook multiple times in a session, I'll
see it listed several times with the same name in the Project Explorer.
From the Project Explorer, I still can access the VB code and forms
even though the workbook itself is closed and not in the main Excel
interface.

The workbooks are not hidden. And if I close and reopen Excel they
disappear form the Project Explorer.

Anyone have any ideas what is going on?