disable dialog box to input password in VBProject

[aryan_hr]

Hi,

I have written a program in Excel (VBA). The program consists of three
workbooks (XLA format), one is main program and other two workbooks
are added to it as reference. And all of the three workbooks have
password. My problem is: When I add a workbook to main workbook as
reference, the main program shows a dialog box for input password that
I cancel it and I don't enter the password. How can I avoid showing
this dialog box?

Best Regards,

 

[aryan_hr]

any idea pleaseeeeeeeeeeeeeeeeee

 

[Richie(UK)]

Hi,

Sorry, but I don't quite follow what you are doing. Could you post the code that you are using?

(Have you tried the usual Application.DisplayAlerts=False?)

 

[aryan_hr]

Thanks for the reply,

I had tried Application.DisplayAlerts=False, but no change!!!
I have two workbooks, W1.xla and W2.xla and both them protect by passwords.
When I add W2.xla to W1.xla as reference:
Workbooks("W1.xla ").VBProject.References.AddFromFile "C:\W2.xla"
a dialog box appears and prompts for input password. What can I do to avoid this dialog box?


Best Regards,