+ Reply to Thread
Results 1 to 5 of 5

Strange VBE Behavior

  1. #1
    Jeff Robson
    Guest

    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

  2. #2
    Norman Jones
    Guest

    Re: Strange VBE Behavior


    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




  3. #3
    Dave Peterson
    Guest

    Re: Strange VBE Behavior

    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

  4. #4
    jgrob3@hotmail.com
    Guest

    Re: Strange VBE Behavior

    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



  5. #5
    Dave Peterson
    Guest

    Re: Strange VBE Behavior

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1