I have some VB code in Excel that is used to search for and load
particular add-ins that may be present in the current directory. All
was working fine until time came to password protect the original
project (that loads the add-ins).

Now the line:

Application.VBE.ActiveVBProject.References.AddFrom File "filename"

causes the user to be prompted for the VB project password. The code
continues to execute past this point without problems regardless of
whether the password is entered OR if the user just hits cancel.

So, question is how to stop the needless VB password prompt?

Any suggestions appreciated.