Password protecting 8 sheets so other users can only view their own sheet

Hello, I know I can right click on a sheet and select "Protect sheet" but I need to do more. I need to make it so the users cannot see sheets to which they should not have access. I have eight users who will each need to open a spreadsheet, view common areas, then enter a password so they can view their own user info on their sheet. How do I do this? I am not a programmer. Thank you in advance

Is this what you are looking to do?
http://office.microsoft.com/en-us/ex...010078580.aspx

Also.. you don't have to be a programmer to learn some basic formulas and such. There is a wealth of free knowledge out there.
Here are a couple resources for Free Microsoft Excel Tutorials.
Hope the link helped !


http://learningcomputer.com/microsof...xcel-2013.html

https://www.youtube.com/watch?v=luW9O_ee3lg

Thank you for the links at the bottom. The first link is not what I need. I know how to protect a sheet from being edited. What I needed was to give users to only the sheets for which they have a password entered correctly. I found this piece of code online and I'm using it successfully:

Here is one way to do as you wish. This does not hide the entire sheet, but scrolls down 1000 rows to a point that you probably do not have data in. Copy the following event handler to the clipboard:

Private Sub Worksheet_Activate()
ActiveWindow.ScrollRow = 1000
pWord = InputBox("Enter password to view the worksheet", "Secure Area")
Select Case pWord
Case Is = "password" <- Enter your own password
ActiveWindow.ScrollRow = 1
Case Else
Sheets("Sheet1").Activate <- Enter your sheet name instead of Sheet1
End Select
End Sub

Select Sheet2 and right click the sheet tab.

Select 'View Code'

Paste the event handler into the editing area to the right.

Close the VBE and return to the worksheet.

Select 'Sheet1'. Reselect Sheet2 and you will be prompted for the password. The correct password will set the scrollrow to 1, otherwise Sheet1 will be reactivated.

If you wish to use a different password, change "password" in line 5 to your preferred password, i.e. "magnoliathunderkitty".

My next problem is this: The passwords work well but when the users open the sheet, if they don't select to enable content, they can view all of the tabs. That would be bad! I now need to remove the enable content bar while at the same time still enabling the VBA code/macros. How do I do this?

Wow! That's a lot of stuff. Thank you. I'll work on it shortly and let you know how it goes. Thanks again

OK, Im pretty confused. I have a piece of VB code already which asks for a password for each sheet. That's working fine. It looks like your VB code hides all of the sheets except a "Welcome To" screen which asks for a password. Name Password
Amy Wagner
Chad Augu87
David donkey
Danielle Peanut1
Brianna Everly
Rachel bubble
Jim Jim6641
Liz LIZZYG
Master sheet Master

These are my employee names (and consequently) the worksheet names and their corresponding passwords. I like your piece of code which locks the workbook and ties a password to it -> ActiveWorkbook.Protect Password:="MyPassword". How can I add that to my spreadsheet? Also, do I need to add your long piece of code to each of my employee named sheets? Im not a programmer

OK, I figured out how to password protect the sheet. I don't need the password pieces since I already have that. Which pieces of your code present the "welcome to" screen and hide all of the other screens until the right password is entered?

You only need to insert the code above into a new module:

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

My code uses a common password for all sheets. You would need to modify it if each sheet has a different password.

To get my code as-is to function in your workbook:

1: Insert a new worksheet and name it "Passwords" or copy the sheet from my workbook into your own
2: Enter your sheetnames and passwords as you provided above into columns A and B of the Passwords sheet.
3: Insert a new sheet and name it "Master" or Copy the sheet from my workbook into your own. (You will have to change the Data Validation for the User field to accommodate your list of users.)
4: Copy the code above into a VBE module, as detailed in the instructions above.
5: Unprotect all sheets and the workbook.
6: Run the "HideWorksheets" macro to hide and protect all sheets except the master.

Now all sheets are hidden by default and selecting a user and entering a correct password will display the selected sheet.

You may also want to put in a line in your workbook on-close event that runs HideWorksheets to clean up from the last user. Once you get the rest up and running to your satisfaction, I will walk you through that part.

OK, Ive added the new module but I'm pretty sure I've messed it up. I've attached it here. Can you take a look at it? I have a piece of VB code on each sheet which I probably need to remove since Im trying to use your welcome to screen idea. Ive password protected the workbook with password Master. Can you tell me what I have wrong? Oh, also, the first three sheets after the welcome screen tab, called Calls Common area, Claims Common area, and Charts should all be open access to everyone at all times. How do I achieve that?

Thanks again for your help

I updated your workbook to work. See attached.

Thank you again

Two questions: 1) The sheet named Amy is visible, how do I fix? and 2) I get the following error message when I run the password. See attached

OK, I enabled macros and that fixed the error message. How do I hide Amy's sheet?

Run the macro "HideWorksheets". It should hide it. Sorry. I didn't realize I had left it visible when I uploaded it.