VBA Project Password Request on Exit

[ilya2004]

Hi all,

Has anyone ever come accross this error:

I have a macro-enabled tool that I send to different users. One of them showed me that when she closes out from the spreadsheet on her computer, it prompts her for the VBA project password after the spreadsheet has already closed. She has to click cancel 10-15 times or enter the password that I have put on the project.

Any ideas what it could be?

 

[dmt32]

Hi all,

Has anyone ever come accross this error:

I have a macro-enabled tool that I send to different users. One of them showed me that when she closes out from the spreadsheet on her computer, it prompts her for the VBA project password after the spreadsheet has already closed. She has to click cancel 10-15 times or enter the password that I have put on the project.

Any ideas what it could be?

have a read of this article & see if helps

Dave

Password prompt for VBA project appears after Excel quits

 

[Jon Peltier]

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:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    ' blah blah before close code

    ThisWorkbook.Saved = True
End Sub

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

 

[andrewb90]

Just tried this as my worksheet has the VBA password box popup frequently, and it did not work.