User Form causing Prompt for VBA Project Password when closing Excel

I have attempted to add a form to authorize use of a workbook. Since adding the form, every time I exit excel after opening the workbook with a valid password, I am prompted to enter VBA Project Password after excel closes. If I remove the PasswordVal.show from the workbook open event code, the problem goes away. Is there something wrong in my code (below) that's causing the issue?

Please Login or Register  to view this content.

The code for the form:

Please Login or Register  to view this content.

I had it before and was solved when i disabled the Acrobat addon from excel.
Look for the addins

hi,
I tried to make a test file using yr data...it seems to work fine without prompted VBA project password...

Yes It causes a problem where the vba projects are kept open after the workbooks are closed. Right?
That was driving me crazy.

We ran into the same issue when our company recently upgraded from Excel 2003 to Excel 2010. After much wasted time, we remedied the problem by disabling Acrobat. The problem is that our users need Acrobat. We were hoping they could use Excel 2010's built in PDF capabilities, but apparently this isn't as convenient. With Acrobat, once the file is converted to PDF, the PDF can be edited by adding comments etc. I suggested that they use Excel's built-in PDF feature to save the file in PDF format and then open it in Acrobat to do further editing. The users thought this was inconvenient since they would have to take extra steps to switch to Acrobat and browse to the PDF. I am hoping to find a solution that will prevent the password prompt without disabling Acrobat. Please let me know if anyone has a solution. Thanks!

This is something you have to ask Adobe for.

In all cases, I shouldnt be asked for such a Fix.

This is a problem that has intermittently plagued my own Excel VBA add-ins for a small number of customers. I've documented the problem in my online documentation: VB Password Dialog - Peltier Tech Charts for Excel - Documentation.

While working on a specific situation for a client, I came up with a solution. I don't know if it only works for his situation (on just my machine) or if it is more widely applicable.

Insert the line "ThisWorkbook.Saved = True" at the end of the Workbook_BeforeClose event:

Please Login or Register  to view this content.

If anyone has a chance to try this, could you let me know if it helps for you and/or your clients.

Originally Posted by Jon_Peltier

If anyone has a chance to try this, could you let me know if it helps for you and/or your clients.

Jon,

I've also encountered this issue with my Excel Add-ins for a small number of clients. I just tested the .Saved method, and, unfortunately, it did not work for my latest customer. Consistent with your article, this customer has many other add-ins installed, so I'm sure mine is being falsely accused.