In Project Explorer why do closed workbooks still appear?

  • Thread starter Excel programming questions
  • Start date
E

Excel programming questions

When I close a workbook and look in Project Explorer it appears as if the
workbook is still open. Excel 2003
 
R

Ronin

Set what you create into Nothing


For Example:

dim mBook as workbook

set mBook = Nothing


Ronin
 
D

Dave Peterson

I've seen this, too.

But it doesn't seem to cause any problems (to excel anyway). So it's just an
irritant to me.

I have no idea why xl does this and no idea how to stop it.

The only way I know to correct it is to close excel and reopen excel.

(Maybe I've been lucky that it hasn't caused a problem????)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
Word 2007 flash screen upside down and Word2007 cannot be used 0
Unwanted workbooks on startup 2
Ignoring a runtime error 1
Workbooks still appear in Project Explorer after closing in Excel? 19
populate a combobox based on unique values in another workbook 16
projects left open in vba after closing workbook 4
Creating Network Diagram using a Chart SW integration 0

Top