Macro to auto update links to password protected workbooks

[armlegx]

I am new to VBA.

I have a master workbook that pulls summary data from several workers' workbooks.

The worker's workbooks are all password protected with unique passwords.

Is there a macro that will let me update links and then enter the passwords to each of the worker's workbooks?

Record macro produced nothing but the name and description.

I tried to use some of the codefrom the last post on this thread http://www.excelforum.com/excel-prog...ugh-vba-2.html but I am getting a runtime error.

Thanks,
Mark