Password protected workbooks

I have one master workbook that has sheets that are linked to 9 other 
workbooks.  The other 9 workbooks have individual passwords.  When I open the 
"master" workbook, I have to enter the other 9 workbook passwords.  How do I 
get around that?  Anybody?
-- 
M.Stanley
0
12/15/2005 9:48:02 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
531 Views

Similar Articles

[PageSpeed] 42

Create the 11th workbook that opens the first 9 (supplying the password) and
then opens the master.

Is it ok to open those other workbooks?

Option Explicit
Sub testme()

    Dim myFileNames As Variant
    Dim myPWDs As Variant
    Dim iCtr As Long
    Dim testStr As String
    
    'put all ten workbook names here
    'end with the master workbook name
    myFileNames = Array("C:\my documents\excel\book1.xls", _
                      "C:\my documents\excel\book2.xls", _
                      "C:\my documents\excel\master.xls")
                      
    'same with the passwords
    myPWDs = Array("pwd1", _
                   "pwd2", _
                   "")
                   
    If UBound(myFileNames) <> UBound(myPWDs) Then
        MsgBox "design error!"
        Exit Sub
    End If
    
    For iCtr = LBound(myFileNames) To UBound(myFileNames)
        On Error Resume Next
        Workbooks.Open Filename:=myFileNames(iCtr), Password:=myPWDs(iCtr)
        If Err.Number <> 0 Then
            MsgBox myFileNames(iCtr) & " didn't open" & vbLf & "Quitting!"
            Err.Clear
            Exit Sub
        End If
    Next iCtr
End Sub



Mike Stanley wrote:
> 
> I have one master workbook that has sheets that are linked to 9 other
> workbooks.  The other 9 workbooks have individual passwords.  When I open the
> "master" workbook, I have to enter the other 9 workbook passwords.  How do I
> get around that?  Anybody?
> --
> M.Stanley

-- 

Dave Peterson
0
petersod (12004)
12/15/2005 11:16:46 PM
Reply:

Similar Artilces:

Password Protect Two Sub-contact Lists
Hi everyone! I have a regular contact list, and within this list I have two subcontact lists. One is personal, and the other is personal business. How can I password protect the personal and personal business lists? Thanks for any help! Sorry, I just realized that there's a newsgroup dedicated to contacts. I'll post this there. Thanks! Nick2112@sympatico.ca wrote: > Hi everyone! > > I have a regular contact list, and within this list I have two > subcontact lists. One is personal, and the other is personal business. > How can I password protect the personal and...

protecting sheet with combox
i'm trying to protect a sheet with a combo box in it. the combox list a bunch of values. each value you pick is linked to a formula which changes a price value in a different cell. i would like to protect the sheet so that the money value that appears in the cell can't be changed by the user. whenever i try to protect the sheet i then can't change the values in the comb box . i want to be able change the values in the combo box but have the formulas and automated cells protected. any ideas? ------------------------------------------------ ~~ Message posted from http://www....

Passwords #5
I would like to password protect a workbook so that when the workbook is selected to open a dialog box pops up asking for the password and after the password is entered correctly the workbook will then open. Thanks for the the help. Todd Todd, do a save as and look under options, depending on what version you are using and set a password to open -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address t...

Passwords
Hi, I have a password field in a database. How do I set it so that a user can only type in 7 characters for a password. and if they type more an error message will appear? Please hi, Daz01 wrote: > Hi, I have a password field in a database. How do I set it so that a > user can only type in 7 characters for a password. and if they type > more an error message will appear? You may use the ValidationRule and ValidationText of the field in the table design view. Setting ValidationRule to Len([YourField])>7) will raise an error in your case. mfG --> stefan <-- ...

Keep user passwords
Hi! We've just finished installing a new Exchange server and connecting it to a separate DC. We used to have everything on the same server but we'd like to be able to scale our solution better in the future - therefore the new setup. Users are primarily connecting to Exchange by means of RPC over HTTP from clients that are not part of our AD. The old setup allowed users to save passwords if they configured their clients to use NTLM authentication and followed the directions in this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;820281. This worked both for RPC...

How to retrive password protected worksheet but forgot password?
I password protected an Excel spreadsheet and now can't remember the password. Is there any way that I can gain access to my worksheet? There are tons of FREE good Excel password 'cracking' tools. Your favorite search engine should get about a gazillion hits on a phrase like "crack excel password" or "excel password cracker". A good one that many report great success with can be found at: http://www.straxx.com/excel/password.html "Laurie" wrote: > I password protected an Excel spreadsheet and now can't remember the > p...

How to protect cells?
I would like to protect a range of cells (A2:D24) with a password for a group of users that would make changes to cells in this range. Then on the same sheet, also protect a range of cells (E2:E24) from everyone but me. Is this possible? Thanks. Mark, Please don't multipost. See the thread in .programming. John "Mark F." <m7829@yahoo.com> wrote in message news:FSzQb.10797$6o4.894@fe2.texas.rr.com... > I would like to protect a range of cells (A2:D24) with a password for a > group of users that would make changes to cells in this range. Then on > the same she...

Spreadsheet password protection
How do you password protect a spreadsheet. I can't find anything in the help section. You can prevent un authorised access by giving a password to open the workbook itself, so that no one else can open it (Go to Tools, Options and then Security Tab). You can do it there if you have already saved the file, or you can go to "save as" then "Tools" and "General Options" where you can give password. On the other hand you can protect work sheets and ranges for different people by using "Tools" and then "Protection" Tab -- M Imran Buha...

quick copy worksheet into other sheets in same workbook
I am wanting to copy a worksheet that is set up to show student results, targets and achievements into approximately 150 other worksheets in the same workbook. Is there a quick way of doing this other than copying and pasting? I want formats, colours and column widths etc to stay the same. In other words I want to produce about 150 identical copies of my layout as quickly as possible with the minimum of effort. I am using Excel 2003. Thanks in advance for any help and advice offered Right-click on the worksheet tab and select "Move or Copy", then use the dialog box that appear...

Shared Workbook Settings, End User Update Changes Refresh Rate
How can I change the default update change refresh rate on PC's that are accessing a shared file? (currently set for 15 minutes, I need 5 Minutes by default). I know how to change it in the share workbook menu for each session, I need to have it always be 5 minutes so that it won't need to be changed each file opening.... ...

Password
I am working with publisher 2007. I finished my site last Dec. and went to make changes. It is not letting me make changes because it does not like my password. I can not figure out how to go in a reset everything from my provider. Any suggestions. I was also trying to see if I could find web publishing wizard, which doesn't seem to exsist with 2007. Thanks If you are saying you forgot your password then contact the ISP Tech Support and they will reset the password to something like 1 2 3 4 or something other that is very simple. They will also instruct you to change it to somethin...

Protection from copying
I have a workbook with hidden cells that I would like to protect (leaving certain cells visible for input). However, even with password protection on the entire workbook, a user can copy all of the cells into another workbook and view/edit/change all of the cells in my workbook. Is there a way around this? thanks Z, If it's formulas you want hidden, use Format - Cells - Protection - Hidden. Then protect the sheet (Tools - Protection - Protect sheet). If it's data, forget it. Users can copy/paste cells , copy the sheet, take a picture of the workbook with PrtScrn (or with ...

Change Password Next Login, Enforce Password Policy and Expiration
I'm curious why are the Change Password Next Login, Enforce Password Policy and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a user. my client want to know how to enable it. hope for your prompt action. -- Jeremy Ayaay Technical Specialist STRC Only works for SQL 2005. If you client wants to use a beta database server... "Jher" wrote: > I'm curious why are the Change Password Next Login, Enforce Password Policy > and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a > user. my client want to know how to enab...

Passwords #3
Using outlook2002. For some reason, it will not store the password. I have checked the box that says "remember password", but, each time I try to log in. It will ask me for it. Any ideas. I am thinking about recreating the profile for thismailbox. I am a consultant, and my customer doesn't know how (or won't write down what I tell them) to do this. Thanks ...

password prompt when no password is set.
thru a series of unfortunate events I had to reinstall my os and all of my programs. I was using ms money 2000. I have always kept the main *.mny file but lost my backups. When i reinstalled money and tried to open my mny file I get a password prompt. I have never password protected the file and when i tried to run a password recovery program it says "no password set". I do have older backups of this file but they are too old to be of much use. But i am able to access them. any suggestions would be appreciated. Thanks BRC The password prompt often appears when you open a dataset m...

Network password #9
I don't use passwords and now i am prompted to enter a network password or my computer will not connect to email account. Any thoughts If you are still having problems after applying both the SP 1 & 2 patches, then see if this article addresses your problemL OL2002: The Save Password Setting Is Not Saved When You Connect to a POP3 Server http://support.microsoft.com/default.aspx?scid=kb;en-us;290684 --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal accoun...

assemble excel workbook
Excel Folks: I'd like to asemble several excel worksheets and/or workbooks into a single workbook. Is there a quicker way to do this than manually cutting and pasting between workbooks? Eg: workbook1 includes sheet a,b, and c wokbook2 includes sheet d,e, and f >> correct incantation occurs << workbook3 includes sheet a,b,c,d,e, and f Similarly, is there a way to import multiple .csv files into a single workbook in one fell swoop? Thanks to anyone who can help! handjive Willie, You can right-click a worksheet tab, and use Move or Copy sheet to get everythi...

How to password protect a selection using the autofilter function?
Hi, Could anyone tell me how I can password protect a selection from using the autofilter option in Excel 2000. The purpose of this is that I have a file that has some data under a couple of people's names. I want the person who selects the data under his/her name to be prompted for a password so only that person can view the data. I know i can seperate the data and send it individually, but if I can do the above, then that would save me some time. If anyone know how to do that please email me at yuppie931@yahoo.com. I really appreciate it. I am not sure if I need to do a VBA or there is...

Password Problem #9
I continioulsy get a popup that says "Enter Network Password" the box show my server, username and password. this box pop up every few seconds. My intenet provider (TimeWarner) says this is an Outlook problem. does anyone have a solution? Thanks -- MikeM "MikeM" <MikeM@discussions.microsoft.com> wrote in message news:27BD7829-84BD-44BD-9114-3FF4D453BD72@microsoft.com... > I continioulsy get a popup that says "Enter Network Password" the box > show > my server, username and password. > > this box pop up every few seconds. My inten...

protecting data when updating/importing
I have text files that are updated every day via a mobile link (SIM card). Each text file is also automatically imported into an excel spreasheet (upon opening the spreadsheet) so that I can look at graphs of the data when I want to. This all seems to work fine, but one day half of the data failed to be updated via the mobile link. Could it be that I happened to import the data into excel just as the data was being updated from the mobile link, and the update was interrupted? If so, is there a way that I could create a mirror image of the text file so that one copy is used for the m...

Password Protection #5
Hi all I have a spreadsheet with several sheets . These are accessed via macr buttons on a main fron sheet (I have hidden other sheets) . Is i possible to password protect certain sheets so that they cannot b accessed by the user without the correct password . I can protect the so that they cannot be changed but need to stop them from bein accessed Thanks Kiera -- Message posted from http://www.ExcelForum.com First Hide the sheet by going Format/Sheet/Hide on the toolbar. If you then protect the workbook structure the user will be unable t unhide the sheet. Dunca -- Message posted fr...

No Password
How do we get into another person's Outlook Express identity without their password? An employee has left the company abruptly. There are important email messages that we need access to in their account but we don't have the password for their identity. I don't see an option for the administrator to re-set the password. How can we get in and get those emails??? lier lol ;O "J" <anonymous@discussions.microsoft.com> wrote in message news:8c6901c4859f$0fdcf650$a401280a@phx.gbl... > How do we get into another person's Outlook Express > identity withou...

CHANIGN PASSWORDS IN OWA
Hello. I've got a pretty simple config. Exchange 2003, single server. I have the change password option setup in OWA, but when users click the button they are prompted for their credentials again, even though they've already logged in. How can I prevent this from prompting them and just have it pass the credentials through? Thanks. Check the security settings on the IISADMPWD virtual directory. See if this helps: http://support.microsoft.com/kb/297121/en-us -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "Dan" <Dan@d...

Outlook logon password
When I open Microsoft Outlook 2003, I can choose between 2 identities. Neither one, however, asks for a password, meaning either one of us can see/use each other's email. How can I set it so after a choose an id to use, it asks for the password before showing my inbox? You can set a password on the .pst file for each of the mail profiles. Open Outlook, then right click on the root of your personal folders. Select Properties then advanced. Use the Change Password option to set your password and DO NOT FORGET IT! --� Milly Staples [MVP - Outlook] Post all replies to the group to keep...

Openning Grouped Columns in Protected Sheets
We want to put such a protection to the sheet that, the protection will not prevent the user from openning grouped columns. This is possible only through a macro, for example: Sub a() With Sheet1 .EnableOutlining = True .Protect , True, True, True, True End With End Sub This setting does not get saved with the workbook, so it must be reset by running this macro each time the workbook is opened. -- Jim Rech Excel MVP ...