is it a virus?

E

!..:: Enang ::..!

Hi

I've closed all the workbook in excel, but it still show a workbook with
sheets in Microsoft Visual Basic Editor. What happen?

Many thanks for any help.

Ndoel
 
D

Dave Peterson

Maybe you have a hidden workbook?

Back to excel
window|unhide

Or maybe you have an addin loaded. Addins end with .xla?

What's the file name?
 
E

!..:: Enang ::..!

No addins and no hide file
the file name is one of my payroll file (gaji.xls)
It's happen only if I open that file
 
D

Dave Peterson

There have been a few posts that describe this problem.

I've seen it, too.

I don't know what causes it, but the only way I can remove that "phantom"
project is to close excel and reopen it.

But I've never seen it cause any trouble, either. (I just ignore it.)
 
E

!..:: Enang ::..!

yes it's not cause any trouble
then I group the sheets and copy and paste to a new file
the 'phantom's gone and I have a new file with ± 150 kb smaller

dave, thank's for ur respon anyway :)
 
D

Dave Peterson

Now I'm confused.

I was writing about the "ghost" project. The workbook that's associated with
that project is really closed.

How do you group sheets and copy them?

!..:: Enang ::..! said:
yes it's not cause any trouble
then I group the sheets and copy and paste to a new file
the 'phantom's gone and I have a new file with ± 150 kb smaller

dave, thank's for ur respon anyway :)
Click to expand...
 
E

!..:: Enang ::..!

I open the file (gaji.xls) and VBE too
I see two projects with the same name dan content - VBAProject (gaji.xls)
Then I go back to excel and I group the sheets and copy all sheets to a new
file (gaji-1.xls)
I close the excel and VBE
I have a new file now with ± 150 kb smaller and without 'ghost' project
 
Top