none
undue password prompt while quitting an Excel VBA application RRS feed

  • Question

  • I created an Excel application with a VBA macro protected by a password. When a user runs the application and quits he is frequently (but not always) prompted to input the VBA password. By clicking many times the cancel button the measage disappears. Someting must be wrong with my programming but what?
    • Moved by kleinma Wednesday, August 10, 2011 3:11 PM (From:Visual Basic Language)
    Wednesday, August 10, 2011 8:56 AM

Answers

All replies

  • This forums is for VB.NET questions. I will move your thread to the VBA section of the forums.

    Also I suggest you reply and provide more information, because it is going to be hard for someone to be able to help you based on that very limited information you have given so far.


    Matt Kleinwaks - MSMVP MSDN Forums Moderator - www.zerosandtheone.com
    Wednesday, August 10, 2011 3:11 PM
  • DimyKha

    Have you seen this link?

    Topic: Password prompt for VBA project appears after Excel quits

    Link: http://support.microsoft.com/kb/280454

    or this one?

    Topic: Stop prompt for password when Excel closes

    Link: http://www.excelforum.com/excel-programming/339794-stop-prompt-for-password-when-excel-closes.html


    Sid (A good exercise for the Heart is to bend down and help another up)

    Please do not email me your questions. I do not answer questions by email unless I get paid for it :) If you want, create a thread in Excel forum and email me the link and I will help you if I can.


    Thursday, August 18, 2011 7:12 PM
    Moderator