embedding pw's to master sheet & auto update w/out pw's
 

i am creating a time and attendance project using excel. there is a master workbook that only the manager will use, and has cells linked to several other workbooks that will need to be updated upon opening. the master workbook has a password. here is the thing, the other workbooks each have their own passwords, and i keep getting hung up when it asks to update and then asks to enter each individual password. i have a macro that skips the "update" question and will run it automatically, but still asks for the pw's, and i have been scouring the forums for 2 days for help on this and cant seem to find one that suits me. there are also hyperlinks to all other workbooks within master, but when i click each one, it ask me for a password. now because i am still creating it, i created all the passwords and know them, and the users are not using the system yet, so i should not be crossing over any boundaries with this question? also, until 2 weeks ago i was completely new to vba, but am getting the hang of it... still new though

so here is what i am trying to do:
1) manager opens master workbook, enters own password - got that
2) bypass question to update - got that
3) macro to run update automatically when master is opened, without asking for the passwords to other workbooks - ???
3)when using master workbook, manager is able to access all other workbooks using hyperlink without entering password for the workbook - ???


i have tried so many different codes to try to get this to work, but it does not seem to. some examples, but not all:

1)Workbooks.Open Filename:="K:filename.xls", UpdateLinks:=3, Password:="pw"
ActiveWorkbook.Close SaveChanges:=True

2)Sub update()
'Don't ask to update
Application.AskToUpdateLinks = False And Application.DisplayAlerts = False
End Sub

any help???