VBA Project Password Dialog Shows On Close

Posted on 2010-01-08
Medium Priority
Last Modified: 2013-11-25
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.
Question by:karinos57
  • 2
LVL 81

Expert Comment

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

Can you upload the workbook?

LVL 81

Accepted Solution

zorvek (Kevin Jones) earned 2000 total points
ID: 26222667
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

LVL 85

Expert Comment

by:Rory Archibald
ID: 26276787
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.

Author Closing Comment

ID: 31674816

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question