Getting Password Prompt while exiting vba project..
I have a big Excel-VBA project, when few users try to exit from the project after using, they get password prompt. They have to keep clicking cancel repeatedly on the password prompt to go. Please let me know how to solve it. Found many discussions on web that its because of Google Desktop, but here the users doesn't have Google desktop loaded on the system. Please help!
It's not just Google Desktop. Any COM addins you have might be the cause - as I think you have already been told.
Be as you wish to seem
I wanted to know if there any other workaround other than removing COM addins. It may need a system admin to remove those addins in users systems. This project is distributed to many users and it will not be easy to remove addins for the users whom its not working. Any other workaround for this?Originally Posted by Aflatoon
Not that I am aware of, no.
Be as you wish to seem
Can you tell me what is the reason they are getting this error, so that I can explain these users.
Not specifically no - as best I know, the addins hold references to the workbooks that prevent them from closing properly (presumably due to imperfect garbage collection) which is why you see the projects in the VBE. I could not begin to tell you the precise mechanics of what is happening under the hood.
Be as you wish to seem
Thanks a lot for explaining!! Please do let me know if you can find any alternative solution for this.
I got this from a microsoft KB article as I recall, but can not find it at the moment. Assuming Excel 2007/2010, do this on the affected machine:
Click the Microsoft Office Button, and then click Excel Options.
Click Advanced, and then scroll to the General area click to clear the "Ignore other applications that use Dynamic Data Exchange (DDE)" check box.
If this is checked, uncheck it.
Click OK.
This fixed the problem for one of my users - however, it could cause others if they need the DDE functionality...
Posting Permissions
Reply With Quote
