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

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

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

Try the below it helped me when i had the same issue.
http://support.microsoft.com/default...b;en-us;214314

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com