|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
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"
'Don't ask to update
Application.AskToUpdateLinks = False And Application.DisplayAlerts = False
|Thread||Thread Starter||Forum||Replies||Last Post|
|auto generate sheets in a workbook from list using a master sheet||Carl||Excel Programming||2||March 1st 10 01:49 PM|
|How can I get data to automatically update using a master sheet?||Julia||Excel Worksheet Functions||0||July 30th 07 05:58 PM|
|how to set up master page that will auto update smaller pages||Chosin healing||Excel Programming||1||January 26th 06 01:22 AM|
|Copying (Master) column to another sheet to automatically update||LostInVirtualSpace||Excel Worksheet Functions||0||September 19th 05 06:57 PM|