+ Reply to Thread + Post New Thread
Results 1 to 15 of 15

User Form causing Prompt for VBA Project Password when closing Excel

  1. #1
    Registered User
    Join Date
    09-03-2009
    Location
    Red Bank, NJ
    MS-Off Ver
    Excel 2010
    Posts
    51

    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?


    copy to clipboard
    Please Login or Register  to view this content.

    The code for the form:

    copy to clipboard
    Please Login or Register  to view this content.
    Last edited by avr5iron; 03-09-2012 at 11:36 AM.

  2. #2
    Registered User
    Join Date
    09-03-2009
    Location
    Red Bank, NJ
    MS-Off Ver
    Excel 2010
    Posts
    51

    Re: User Form causing Prompt for VBA Project Password when closing Excel

    In the course of testing on different machines, I have discovered that the issue only exists when I open the file from the recent files list (I've verified the path and made sure it's the same file). If I open it from file open, it doesn't happen. Working with Excel 2010. Has anyone ever encountered differing behavior based on how the file is opened.

  3. #3
    Registered User
    Join Date
    09-03-2009
    Location
    Red Bank, NJ
    MS-Off Ver
    Excel 2010
    Posts
    51

    Re: User Form causing Prompt for VBA Project Password when closing Excel

    Disregard my last post. The issue is recurring no matter how the file is opened.

  4. #4
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: User Form causing Prompt for VBA Project Password when closing Excel

    I had it before and was solved when i disabled the Acrobat addon from excel.
    Look for the addins
    Regards,
    Khaled Elshaer
    www.BIMcentre.com

    Remember To Do the Following....
    1. Thank those who have helped you by clicking the Star below their post.
    2. Mark your post SOLVED if it has been answered satisfactorily:
    • Select Thread Tools (on top of your 1st post)
    • Select Mark this thread as Solved

  5. #5
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel 2007
    Posts
    1,898

    Re: User Form causing Prompt for VBA Project Password when closing Excel

    hi,
    I tried to make a test file using yr data...it seems to work fine without prompted VBA project password...
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  6. #6
    Registered User
    Join Date
    09-03-2009
    Location
    Red Bank, NJ
    MS-Off Ver
    Excel 2010
    Posts
    51

    Re: User Form causing Prompt for VBA Project Password when closing Excel

    Khaled,

    Thank you. When I disabled the Acrobat com add-on the problem went away. In addition, it resolved an issue i've been dealing with since last week through a separate thread.

    Tony

  7. #7
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: User Form causing Prompt for VBA Project Password when closing Excel

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

  8. #8
    Registered User
    Join Date
    09-03-2009
    Location
    Red Bank, NJ
    MS-Off Ver
    Excel 2010
    Posts
    51

    Re: User Form causing Prompt for VBA Project Password when closing Excel

    Can't thank you enough. I've been going nuts.

  9. #9
    Registered User
    Join Date
    03-16-2012
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: User Form causing Prompt for VBA Project Password when closing Excel

    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!
    Last edited by bed; 03-16-2012 at 11:07 AM.

  10. #10
    Registered User
    Join Date
    07-30-2010
    Location
    South Pole
    MS-Off Ver
    Excel 2010
    Posts
    99

    Re: User Form causing Prompt for VBA Project Password when closing Excel

    Quote Originally Posted by bed View Post
    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!
    Agreed! Disabling the Acrobat add-in is not the solution. Were you able to figure out a fix? Our users are starting to get this problem too and we have spent quite a few man-hours trying to figure out a fix. Thanks.

  11. #11
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: User Form causing Prompt for VBA Project Password when closing Excel

    This is something you have to ask Adobe for.

  12. #12
    Registered User
    Join Date
    07-30-2010
    Location
    South Pole
    MS-Off Ver
    Excel 2010
    Posts
    99

    Re: User Form causing Prompt for VBA Project Password when closing Excel

    Quote Originally Posted by Kelshaer View Post
    This is something you have to ask Adobe for.
    Adobe is the latest player to this issue. A quick Google search shows that this problem has been around since at least 2004.
    They have been due to various types of add-ins which when disabled would make the issue go away.
    So I think the fix has to be in Excel.

  13. #13
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: User Form causing Prompt for VBA Project Password when closing Excel

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

  14. #14
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: User Form causing Prompt for VBA Project Password when closing Excel

    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:

    copy to clipboard
    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.
    Jon Peltier
    http://PeltierTech.com/

  15. #15
    Registered User
    Join Date
    05-16-2015
    Location
    United States
    MS-Off Ver
    2010
    Posts
    1

    Re: User Form causing Prompt for VBA Project Password when closing Excel

    Quote Originally Posted by Jon_Peltier View Post
    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.
    Ryan Wells
    wellsr.com

+ Reply to Thread + Post New Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts