Getting Password Prompt while exiting vba project

Michael M

Well-known Member

Joined

Oct 27, 2005

Messages

21,852

Office Version

1. 365
2. 2019
3. 2013
4. 2007

Platform

1. Windows

• Mar 20, 2012

• #2

So when they exit from the project, you must have a Workbook_beforeclose OR Beforesave event firing.
You may benefit from posting the exit code, and someone will assist with finding the problem.

 

Upvote 0

H

harry1805

New Member

Joined

Feb 23, 2012

Messages

18

• Mar 20, 2012

• #3

This is the exit code:

Code:

Private Sub ExitButton1_Click()
ThisWorkbook.Close False
End Sub

 

Upvote 0

Colin Legg

MrExcel MVP

Joined

Feb 28, 2008

Messages

3,503

Office Version

1. 365

Platform

1. Windows

• Mar 20, 2012

• #4

Does the user have google desktop installed?


Relevant links -

http://www.dailydoseofexcel.com/archives/2004/12/11/google-desktop/

http://support.microsoft.com/kb/280454

http://www.excelforum.com/excel-programming/749838-vba-password-prompt-after-excel-closes.html

 

Upvote 0

H

harry1805

New Member

Joined

Feb 23, 2012

Messages

18

• Mar 20, 2012

• #5

No the user doesn't have Google Desktop. Its just few users who have this problem, majority are not getting this error prompt.

 

Upvote 0

Colin Legg

MrExcel MVP

Joined

Feb 28, 2008

Messages

3,503

Office Version

1. 365

Platform

1. Windows

• Mar 20, 2012

• #6

My guess is it is being caused by an add-in. There are some instructions and some code on the 3rd link (ExcelForum) which should help you investigate it.

 

Upvote 0

T

Tim_K

New Member

Joined

Mar 7, 2012

Messages

40

• Mar 20, 2012

• #7

not sure but try...

Code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = 0
End Sub

 

Upvote 0

RoryA

MrExcel MVP, Moderator

Joined

May 2, 2008

Messages

42,330

Office Version

1. 365
2. 2016

Platform

1. Windows
2. MacOS

• Mar 20, 2012

• #8

Adobe PDFMaker COM add-in seems to be a common culprit at the moment. Seen a few reports of it recently.

 

Upvote 0

H

harry1805

New Member

Joined

Feb 23, 2012

Messages

18

• Mar 20, 2012

• #9

Code:

Sub DisconnectCOM()
Dim objCOMAdddin as COMAddin      
For Each objCOMAddin In Application.COMAddIns         
objCOMAddin.Connect = False      
Next objCOMAddinEnd Sub
</PRE>

got this code from third link to remove com object hope this works, i will try to put it on exit button sub and tell users to test this out.

 

Last edited: Mar 20, 2012

Upvote 0

H

harry1805

New Member

Joined

Feb 23, 2012

Messages

18

• Mar 20, 2012

• #10

It gives error that its a user defined type and not defined.

Code:

Dim objCOMAdddin As COMAddin

not sure what to do now?

 

Upvote 0