I want to update links in an AutoOpen macro. The source file is passworded.
I have tried working with:

ActiveWorkbook.UpdateLink Name:="C:\Book2.xls", Type:=xlExcelLinks

but it asks for the password to update. Is there a way to do this code so I
can password the source file and have the Update Link process work without
the user having to input the password.

Thank you for your help.

Steven