VBA Project not close after file closed

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I have code that opens a file and close's it as a saveas in a different
folder. Problem is that when I go into VBA code the last file that was closed
it VBA Project is still open. How can it be closed and removed from the
Window?
Rick
 
This seems to happen every so often.

It's never caused me any trouble -- but if you make changes to one of the ghost
projects, you'll be wasting your time -- since the workbook isn't really there.
So it can be confusing/dangerous.

The only way I know to get rid of it is to close excel and reopen it.
 
Thanks Dave:

Dave Peterson said:
This seems to happen every so often.

It's never caused me any trouble -- but if you make changes to one of the ghost
projects, you'll be wasting your time -- since the workbook isn't really there.
So it can be confusing/dangerous.

The only way I know to get rid of it is to close excel and reopen it.
Click to expand...
 

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

Project - VBA Project window - Excel 2003 7
VBA Project Password Changed on its own?!?! 0
Excel 2007 - VBA Password Input shows after Excel is closed 3
closing a vba project - dumb question 2
Using Excel to WRITE to a closed Excel file 2
vba project still visible in vba-editor after closing workbook 0
Excel VBA - Problem with Closing Print Preview 0
What is proper way to Open Close Release xls files in VBA? 3

Back
Top