VBA Project Password Dialog Shows On Close

Hi,
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.
karinos57Asked:
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

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

Can you upload the workbook?

Kevin
0
 
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.
0
 
karinos57Author Commented:
tx
0
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.