Loading Add-ins to a Protected Project

[David G Stevens]

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.AddFromFile "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.

 

[Jim Rech]

I haven't tried to reproduce the problem but can't you just open the add-in
and skip setting a reference to it? If you need to call code in the add-in
you could use Run.

 

[David G Stevens]

Run is what is used next.

My point is that under all circumstances the code executes properly
and the required add-ins are loaded, but when the main project is
password protected the line mentioned previously causes the user to be
prompted for the VB Project password. Since the password is not
actually required (code executs fine if the user simply cancels the pw
request) then how can I stop the prompt?

Once again any help appreciated.