Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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???
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
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 02: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 02:22 AM
Copying (Master) column to another sheet to automatically update LostInVirtualSpace Excel Worksheet Functions 0 September 19th 05 06:57 PM


All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"