Strange VBE Behavior

Using XL2003 on Win XP Pro with all the latest patches etc, a rather
strange thing is now occurring in the VBE.

Each time I open a file in Excel, it appears in the VBAProject list
(as per normal) and all works as expected ... no problems there.

However, when I close the file in Excel, the listing in the VBAProject
window doesn't update and still shows the file I just closed.

Furthermore, even with no files open in Excel, I can still view the
closed file's VBA project modules & code (I haven't tried userforms
but I expect they would be the same).

If I open my original file again, I then get two files with the same
name showing in my VBE.

The only way I've found to clear the VBAProject list is to close and
re-open Excel.

I tried Excel's detect & repair but that didn't make any difference.

Any ideas? It's really annoying!

TIA

Jeff Robson

Hi Jeff,

Do you have the Google Desktop application?

---
Regards,
Norman



"Jeff Robson" <jgrob3@hotmail.com> wrote in message
news:c0575922.0501130048.6cadd820@posting.google.com...
> Using XL2003 on Win XP Pro with all the latest patches etc, a rather
> strange thing is now occurring in the VBE.
>
> Each time I open a file in Excel, it appears in the VBAProject list
> (as per normal) and all works as expected ... no problems there.
>
> However, when I close the file in Excel, the listing in the VBAProject
> window doesn't update and still shows the file I just closed.
>
> Furthermore, even with no files open in Excel, I can still view the
> closed file's VBA project modules & code (I haven't tried userforms
> but I expect they would be the same).
>
> If I open my original file again, I then get two files with the same
> name showing in my VBE.
>
> The only way I've found to clear the VBAProject list is to close and
> re-open Excel.
>
> I tried Excel's detect & repair but that didn't make any difference.
>
> Any ideas? It's really annoying!
>
> TIA
>
> Jeff Robson

And if you do, this was posted recently:

From: "Jeff" <jeffreywsm...@earthlink.net> - Find messages by this author
Date: Sat, 18 Dec 2004 06:07:50 -0800
Local: Sat, Dec 18 2004 6:07 am
Subject: Re: VBAProject Password error window from Excel


A solution for at least some of the Google Desktop Search program and
associated VBE issues (the duplicate VBA projects in VBE) has been
found - perhaps that could help with this issue, too - check this post
I started at Experts Exchange (solution excerpted below):


http://www.experts-exchange.com/Appl...Excel/Q_211917...

"You are not going to believe this one (I didn't anyway).

The culprit is the registry key

HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Office.Desktop.Google.com\LoadBehavior
It was set to 3. I set it to 2 and all is well.



Jeff Robson wrote:
>
> Using XL2003 on Win XP Pro with all the latest patches etc, a rather
> strange thing is now occurring in the VBE.
>
> Each time I open a file in Excel, it appears in the VBAProject list
> (as per normal) and all works as expected ... no problems there.
>
> However, when I close the file in Excel, the listing in the VBAProject
> window doesn't update and still shows the file I just closed.
>
> Furthermore, even with no files open in Excel, I can still view the
> closed file's VBA project modules & code (I haven't tried userforms
> but I expect they would be the same).
>
> If I open my original file again, I then get two files with the same
> name showing in my VBE.
>
> The only way I've found to clear the VBAProject list is to close and
> re-open Excel.
>
> I tried Excel's detect & repair but that didn't make any difference.
>
> Any ideas? It's really annoying!
>
> TIA
>
> Jeff Robson

--

Dave Peterson

Thanks Dave

Well, I don't have the Google desktop search program ... however I do
have the ACT! add-in for Excel installed which comes up under the
addins key and also has a loadbehavior key set to 3.

I changed this to 2 and will see if this rectifies the problem when I
reboot.

Does anyone know what this key actually does?

Thank you

Jeff Robson

Dave Peterson wrote:
> And if you do, this was posted recently:
>
> From: "Jeff" <jeffreywsm...@earthlink.net> - Find messages by this
author
> Date: Sat, 18 Dec 2004 06:07:50 -0800
> Local: Sat, Dec 18 2004 6:07 am
> Subject: Re: VBAProject Password error window from Excel
>
>
> A solution for at least some of the Google Desktop Search program and
> associated VBE issues (the duplicate VBA projects in VBE) has been
> found - perhaps that could help with this issue, too - check this
post
> I started at Experts Exchange (solution excerpted below):
>
>
>
http://www.experts-exchange.com/Appl...Excel/Q_211917...
>
> "You are not going to believe this one (I didn't anyway).
>
> The culprit is the registry key
>
>
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Office.Desktop.Google.com\LoadBehavior
> It was set to 3. I set it to 2 and all is well.
>
>
>
> Jeff Robson wrote:
> >
> > Using XL2003 on Win XP Pro with all the latest patches etc, a
rather
> > strange thing is now occurring in the VBE.
> >
> > Each time I open a file in Excel, it appears in the VBAProject list
> > (as per normal) and all works as expected ... no problems there.
> >
> > However, when I close the file in Excel, the listing in the
VBAProject
> > window doesn't update and still shows the file I just closed.
> >
> > Furthermore, even with no files open in Excel, I can still view the
> > closed file's VBA project modules & code (I haven't tried userforms
> > but I expect they would be the same).
> >
> > If I open my original file again, I then get two files with the
same
> > name showing in my VBE.
> >
> > The only way I've found to clear the VBAProject list is to close
and
> > re-open Excel.
> >
> > I tried Excel's detect & repair but that didn't make any
difference.
> >
> > Any ideas? It's really annoying!
> >
> > TIA
> >
> > Jeff Robson
>
> --
>
> Dave Peterson

I don't.

Take good notes or backup your registry before playing in there!

jgrob3@hotmail.com wrote:
>
> Thanks Dave
>
> Well, I don't have the Google desktop search program ... however I do
> have the ACT! add-in for Excel installed which comes up under the
> addins key and also has a loadbehavior key set to 3.
>
> I changed this to 2 and will see if this rectifies the problem when I
> reboot.
>
> Does anyone know what this key actually does?
>
> Thank you
>
> Jeff Robson
>
> Dave Peterson wrote:
> > And if you do, this was posted recently:
> >
> > From: "Jeff" <jeffreywsm...@earthlink.net> - Find messages by this
> author
> > Date: Sat, 18 Dec 2004 06:07:50 -0800
> > Local: Sat, Dec 18 2004 6:07 am
> > Subject: Re: VBAProject Password error window from Excel
> >
> >
> > A solution for at least some of the Google Desktop Search program and
> > associated VBE issues (the duplicate VBA projects in VBE) has been
> > found - perhaps that could help with this issue, too - check this
> post
> > I started at Experts Exchange (solution excerpted below):
> >
> >
> >
> http://www.experts-exchange.com/Appl...Excel/Q_211917...
> >
> > "You are not going to believe this one (I didn't anyway).
> >
> > The culprit is the registry key
> >
> >
> HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Office.Desktop.Google.com\LoadBehavior
> > It was set to 3. I set it to 2 and all is well.
> >
> >
> >
> > Jeff Robson wrote:
> > >
> > > Using XL2003 on Win XP Pro with all the latest patches etc, a
> rather
> > > strange thing is now occurring in the VBE.
> > >
> > > Each time I open a file in Excel, it appears in the VBAProject list
> > > (as per normal) and all works as expected ... no problems there.
> > >
> > > However, when I close the file in Excel, the listing in the
> VBAProject
> > > window doesn't update and still shows the file I just closed.
> > >
> > > Furthermore, even with no files open in Excel, I can still view the
> > > closed file's VBA project modules & code (I haven't tried userforms
> > > but I expect they would be the same).
> > >
> > > If I open my original file again, I then get two files with the
> same
> > > name showing in my VBE.
> > >
> > > The only way I've found to clear the VBAProject list is to close
> and
> > > re-open Excel.
> > >
> > > I tried Excel's detect & repair but that didn't make any
> difference.
> > >
> > > Any ideas? It's really annoying!
> > >
> > > TIA
> > >
> > > Jeff Robson
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson