VBAProject duplicates

[nope]

Ok I have been looking here and know this happens but not why.

I have a workbook with macros written with excel97 then moved to 2000
later. I am finally getting around to making everything cleaner.

I open two worksheets to copy calendar and sales data into monthlly
goal sheets and everything has always worked fine.

Now in excel2003 I am getting out of memory errors and the Project
Explorer shows multiple copies of each VBAProject open. As many as
three of the calendar workbook.

I know you guys can help me. Why I am confused is that I never saw
this in excel2000 and if it is a references problem, shouldn't I have
had the problem before?

Thank You all,
SDenton

 

[Ron de Bruin]

Hi

Do you have Google desktop installed?
See
http://www.dicks-blog.com/archives/2004/12/11/google-desktop/

 

[nope]

Thank You for this reply. Yes I thought this was exactly the cause.
Additionally there is a registry key which can be changed and allows
you to keep Google Desktop Search
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.
http://www.dicks-blog.com/archives/2004/12/11/google-desktop/

Hooray this was a definite answer. Thank you Ron

 

[Ron de Bruin]

Thanks for the feedback

 

[nope]

I wonder if the registry change for this changed Excel so that now I
am unable to seach VBA projects.
search works in a worksheet but not in VBE.
I have seen a couple posts about VBE searching being broken but no
responses.

Any ideas?

 

[nope]

Uninstalling Google Dektop search didn't fix the VBE search if anyone
else wants to know.