VBA Project Password Dialog Shows On Close

I have excel 2007 application with some vba in it.  The problem is that whenever i close  the workbook, i get the VBA Project Password Dialog box shows up.  Can someone provide me a solution for this problem?  thanks.
Who is Participating?
zorvek (Kevin Jones)ConsultantCommented:
If you are calling an ActiveX DLL you may have this problem:

Title: Password prompt for VBA project appears after Excel quits
Link: http://support.microsoft.com/kb/280454

zorvek (Kevin Jones)ConsultantCommented:
Is the VBA project password protected? If so, have you tried removing the password?

Can you upload the workbook?

Rory ArchibaldCommented:
THis can also happen due to certain COM add-ins (Google Desktop used to cause it for some people). You can check in the registry to see if their LoadBehavior key is set to 3 - if so change it to 2, or uninstall it. You can also simply try disabling them all and adding them back one by one to see which is causing the problem.
karinos57Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.