you could use a macro to unlock the sheets or unlock the cells is another
possible solution

"KevinG" wrote:

Hi,

I'm linking from a summary workbook to several workbooks that are password
protected. Everytime I update links I have to put in the password for each
workbook. Is there anyway I can get round having to type in the password for
each workbook everytime I update links?

Hope you can help

Many thanks

Kevin