How can I enter a workbook password automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top