VBA Password Msg Shows Up Mysteriously

[JK]

Forgive me if this is not appropriate for this group, but I'm hoping someone
might have an answer or can suggest someone who might. My application (Excel
97 and newer, Win 97 and newer) computes numbers. The program works fine,
but one customer is having a mysterious problem. When he closes the
application (.xls) he receives the VBA Password MsgBox that we typically get
when we open our password-protected code. He has to alt-delete it about 3-4
times to make it go away. He has no active add-ins, and is not trying to
open the code section. What in the world is going on? Please help if you
can.

TIA

Jim Kobzeff

 

[Jim Rech]

That's a good question. I've seen posts like this before but I haven't seen
an answer. I wonder though if the problem occurs when the user starts in
"safe mode". From Start->Run enter "Excel /s" and press Enter (no quotes,
there is a space before the slash). This loads Excel without most add-ins,
personal utilities or menu customizations. If the problem goes away that
would suggest that something being loaded is the cause.

/s does allow Com Add-ins to open unfortunately but VBE COM add-ins (if any)
can be removed via the VBE's Add-ins, Add-in Manager command.

 

[Ron de Bruin]

Hi Jim and JK

See
http://www.dicks-blog.com/archives/2004/12/11/google-desktop/

 

[Dave Peterson]

Saved from a previous post:

There have been a few problems associated with Google's Desktop Search. Do you
have that installed on your pc?

If yes, maybe disabling that COM Add-In will help.

One way to turn it off:

In excel,
Tools|customize|Commands tab|Tools Category
Scroll down the commands listbox and
Drag "COM Add-ins..." to under Tools|Addins
(It seems to make sense there.)

Then close up that dialog.

Back to Tools|COM Add-ins...
Turn off the google desktop search addin.

(You could use a registry tweak, too. But I think that this is safer/easier.)

===
This google addin shows up in other Office applications, too. You may want to
look at disabling it in those other office programs, too (well, if you
experience problems).