Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
JK JK is offline
external usenet poster
 
Posts: 78
Default VBA Password Msg Shows Up Mysteriously

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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default VBA Password Msg Shows Up Mysteriously

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.

--
Jim
"JK" wrote in message news:1cA3e.4015$Jn2.494@trnddc09...
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default VBA Password Msg Shows Up Mysteriously

Hi Jim and JK

See
http://www.dicks-blog.com/archives/2...oogle-desktop/


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jim Rech" wrote in message ...
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.

--
Jim
"JK" wrote in message news:1cA3e.4015$Jn2.494@trnddc09...
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





  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,758
Default VBA Password Msg Shows Up Mysteriously

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).

JK wrote:

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


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Row mysteriously getting deleted PeteJ Excel Discussion (Misc queries) 0 June 19th 08 05:58 PM
Date changes mysteriously JMH Excel Worksheet Functions 2 January 23rd 08 06:59 AM
Column mysteriously shifts up/down Robin Excel Discussion (Misc queries) 1 October 3rd 07 08:04 PM
date changes mysteriously when copied digicat Excel Discussion (Misc queries) 2 February 20th 06 03:06 PM
userform mysteriously unloads Scott Excel Programming 0 September 1st 03 02:24 AM


All times are GMT +1. The time now is 01:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"