Strange VBE Behavior

  • Thread starter Thread starter Jeff Robson
  • Start date Start date
J

Jeff Robson

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" <[email protected]> - 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/Applications/MS_Office/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.
 
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
 
Back
Top