If you will always get a password dialog when updating the links you
could try using SendKeys to send the password

SendKeys "VerySecret~" ' the ~ is the Enter key
ActiveWorkbook.UpdateLink ....

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup