Automatically input password on linked workbook

[DrH100]

Hi all, hope someone can help me please.

I have 2 workbooks that are linked together.

Book1 pulls information from Book2 and displays it in a table and graph for colleagues to use.

Book 2 is password protected so that only I can view the details in it. The password is currently "lion".

When my colleagues open Book1 they are prompted to input the password for Book2 in order update the links so I put

Private Sub Workbook_Open()
Workbooks.Open Filename:="Book 2 File path etc", Password:="lion"
ActiveWindow.Close
End Sub

in to Book1 in the hope that this would open book 2 input the password and close Book2 taking away the need - which works but only after my colleague inputs the password - defeating the object.

I guess my question therefore is, is there a way that when Book1 is open and the password for book 2 is requested it can automatically be complete, links updated without the users getting access to book 2?

Hope that makes some sense but I still pretty new to this VBA stuff and this is way over my head

 

[JazzSP8]

Hi

Is it password protected to open and modify?

Try this;

Workbooks.Open Filename:="Book 2 File path etc", Password:="lion", WriteResPassword:="lion"

I don't know if that'll solve your problem, or what else to try if not though, so fingers crossed that'll work

 

[DrH100]

Thanks for the reply

Not quite what I needed but not something I hadnt considered. Think I've solved my problem though using a copy and paste method.

Thanks very much.