How can I enter a workbook password automatically

[Guest]

Hi
I have a set of 6 user workbooks each of which is uniquely passworded (one
worksheet in each).
I then have a "master" workbook, which is also uniquely passworded, that
links to each of the 6 user workbooks to gather the worksheet information
into one place.

When the master is opened, Excel asks for the master password (which is
fine) but it also then asks for each of the 6 user workbook passwords.
Can I code the 6 usere workbook passwords into the master to save entering
them everytime? Perhaps by macro or something?

 

[Guest]

The prompt happens before any macros run, so I would see no way to do what
you want.

 

[Guest]

There is presumably some code in the workbook_open event that is opening
these secondary workbooks. You can add the password using something like:-

Set mybook = Workbooks.Open(Filename:=MyPath & MyFiles(Fnum), _
Password:="MyPassword")

If you post the code then it would make things easier.

Mike