Based on Tom Ogilvy's remarks at the site link below, the workbooks will
need to be open for the links. That means that to avoid the user having to
enter passwords for each workbook, it would have to be done with the code
when the master workbook opens.

http://en.allexperts.com/q/Excel-105...ooks-Rules.htm



"Libby" wrote in message
...
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.