Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row mysteriously getting deleted | Excel Discussion (Misc queries) | |||
Date changes mysteriously | Excel Worksheet Functions | |||
Column mysteriously shifts up/down | Excel Discussion (Misc queries) | |||
date changes mysteriously when copied | Excel Discussion (Misc queries) | |||
userform mysteriously unloads | Excel Programming |