Thanks.......

I've had a go at a macro to unlock the sheets but didn't have much luck, do
you have any idea how to go about it?

"jhyatt" wrote:

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