PDA

View Full Version : Enter a password for multiple protected work books



Tgroove
11-02-2018, 07:20 AM
Hi All,

Please excuse me, I am a total beginner at this.

This is my dilemma. I have multiple work books which are protected with a universal password.
All of these protected workbooks are linked to on master workbook where it gets the data from the protected workbooks.

Because we have protected the documents, when opening the master document I have to manually enter the password for each workbook it is linked too.

Is there some sort of code where it can enter the password multiple times?

I have some basic code which only does it automatically for one linked document? Can I not just repeat the line until it does it for all linked workbooks?

Sub Button1_Click()
'
' Button1_Click Macro
'

'

ChDir "C:\Users\kingt\Desktop"
Workbooks.Open Filename:="C:\Users\kingt\Desktop\MASTER.xlsx", UpdateLinks:=3, Password:="0dear"

End Sub

I hope someone can help me....

Thanks,

T

macropod
11-02-2018, 02:18 PM
This is a duplicate of: http://www.vbaexpress.com/forum/showthread.php?63978-VBA-Help-Automatically-entering-passwords-on-multiple-workbooks
Kindly don't ask the same question in multiples threads. Thread closed. You may continue the discussion in your other thread.