Password to linked protrected excel sheets | Excel forum

Hi there,

I wonder if someone could help me.

I have multiple documents which are all protected by single same password. I have a master document which is linked to the these documents which draws data from them.

Since putting the passwords on the workbooks, I am now having to re-enter the password for every linked document in the master document.

Is there some sort of VBA code I can use which will enter all the passwords in for me automatically? maybe some kind of line repeat or loop? I'm struggling as I haven't a clue about VBA programming, so any assistance would be greatly appreciated.

Here is my code, which enables me to automatically enter the password in for one linked documents, after that I have to manually enter it in for the rest.

Sub Button1_Click()
'
' Button1_Click Macro
'

'
ChDir "U:\WIP\Stuff"
Workbooks.Open Filename:="U:\WIP\Stuff\MASTER BOOK.xlsx", UpdateLinks:=0, Password:="0dear"
End Sub

I look forward to hearing from you someone.


Best,

Trevor