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
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
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?
"!..:: Enang ::..!" wrote:
>
> 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
--
Dave Peterson
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
"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:4326B83D.845D587@verizonXSPAM.net...
> 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?
>
> "!..:: Enang ::..!" wrote:
> >
> > 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
>
> --
>
> 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.)
"!..:: Enang ::..!" wrote:
>
> 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
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:4326B83D.845D587@verizonXSPAM.net...
> > 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?
> >
> > "!..:: Enang ::..!" wrote:
> > >
> > > 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
> >
> > --
> >
> > Dave Peterson
--
Dave Peterson
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
"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:43281907.84558ED7@verizonXSPAM.net...
> 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.)
>
> "!..:: Enang ::..!" wrote:
> >
> > 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
> >
> > "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> > news:4326B83D.845D587@verizonXSPAM.net...
> > > 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?
> > >
> > > "!..:: Enang ::..!" wrote:
> > > >
> > > > 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
> > >
> > > --
> > >
> > > Dave Peterson
>
> --
>
> 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 ::..!" wrote:
>
> 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
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:43281907.84558ED7@verizonXSPAM.net...
> > 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.)
> >
> > "!..:: Enang ::..!" wrote:
> > >
> > > 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
> > >
> > > "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> > > news:4326B83D.845D587@verizonXSPAM.net...
> > > > 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?
> > > >
> > > > "!..:: Enang ::..!" wrote:
> > > > >
> > > > > 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
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> >
> > --
> >
> > Dave Peterson
--
Dave Peterson
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
"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:43296A9E.CDAF438E@verizonXSPAM.net...
> 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 ::..!" wrote:
> >
> > 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
> >
> > "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> > news:43281907.84558ED7@verizonXSPAM.net...
> > > 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.)
> > >
> > > "!..:: Enang ::..!" wrote:
> > > >
> > > > 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
> > > >
> > > > "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> > > > news:4326B83D.845D587@verizonXSPAM.net...
> > > > > 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?
> > > > >
> > > > > "!..:: Enang ::..!" wrote:
> > > > > >
> > > > > > 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
> > > > >
> > > > > --
> > > > >
> > > > > Dave Peterson
> > >
> > > --
> > >
> > > Dave Peterson
>
> --
>
> Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks