K
klight20
i am creating a time and attendance project using excel. there is
master workbook that only the manager will use, and has cells linked t
several other workbooks that will need to be updated upon opening. th
master workbook has a password. here is the thing, the other workbook
each have their own passwords, and i keep getting hung up when it ask
to update and then asks to enter each individual password. i have
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
days for help on this and cant seem to find one that suits me. there ar
also hyperlinks to all other workbooks within master, but when i clic
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 usin
the system yet, so i should not be crossing over any boundaries wit
this question? also, until 2 weeks ago i was completely new to vba, bu
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, withou
asking for the passwords to other workbooks - ???
3)when using master workbook, manager is able to access all othe
workbooks using hyperlink without entering password for the workbook
???
i have tried so many different codes to try to get this to work, but i
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??
master workbook that only the manager will use, and has cells linked t
several other workbooks that will need to be updated upon opening. th
master workbook has a password. here is the thing, the other workbook
each have their own passwords, and i keep getting hung up when it ask
to update and then asks to enter each individual password. i have
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
days for help on this and cant seem to find one that suits me. there ar
also hyperlinks to all other workbooks within master, but when i clic
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 usin
the system yet, so i should not be crossing over any boundaries wit
this question? also, until 2 weeks ago i was completely new to vba, bu
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, withou
asking for the passwords to other workbooks - ???
3)when using master workbook, manager is able to access all othe
workbooks using hyperlink without entering password for the workbook
???
i have tried so many different codes to try to get this to work, but i
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??