Hi Guys,

I have a workbook which has links to a number of other workbooks which
require passwords to open them.
The problem is that when the workbook is opened, the user is prompted for
the passwords for each of the protected workbooks that link to it.

Is there any way of updating the links to these password protected
workbooks, or to progammatically enter the passwords without actually opening
the workbooks?

Many thanks in advance.