Hi Rich,
If you enter the code and all the tabs are hidden then you create a menu for
each tab you want to open, Let's say you have sheet A to be seen by user
Peter and sheet B to be seen by user George. Your menu will have to buttoms
one that will say Sheet A and other sheet B. With the macro provided you save
it in Sheet A and B but change the password in one of them so when peter push
the buttom Sheet A it will ask for the password that only he has and only
will open that sheet, if peter wants to use his password to open sheet B
won't be able. Hope this explanation helps, I have an spreadsheet set up in
that way, Then when in sheet A you will want a button that says menu that
when pressed will hide the sheet and return to the menu tab

"Rich" wrote:

I did it but even though it restricts access to change anything it still
doesn't stop someone from viewing it. I need each tab to be viewed by only
the one person that I give the password to.
--
Rich


"Eduardo" wrote:

Hi Rich,
In the sheet you want to hide and unhide with a password, right click with
the mouse on the tab name and then copy this code, then hide it, when trying
to open the sheet from the Menue it will ask for the password, change
password to yours

Private Sub Worksheet_Activate()
Dim strPassword As String
On Error Resume Next
Me.Protect Password:="MANAGER"
Me.Columns.Hidden = True

strPassword = InputBox("Enter password to access DATA sheet")

If strPassword = "" Then
ActiveSheet.Visible = False
Worksheets("Menu").Select
Exit Sub
ElseIf strPassword < "MANAGER" Then
MsgBox "Password Incorrect "
ActiveSheet.Visible = False
Worksheets("Menu").Select
Exit Sub
Else
Me.Unprotect Password:="MANAGER"
Me.Columns.Hidden = False
End If
Range("A1").Select
On Error GoTo 0
End Sub

Private Sub Worksheet_Deactivate()
On Error Resume Next
Me.Columns.Hidden = True
On Error GoTo 0
End Sub



"Rich" wrote:

I have tabs in an excel spreadsheet set up for different individuals. I want
to put in a password that allows that specific user to open up their tab only
so that only they can view their information in that tab. I will then put
the file in a shared folder.
--
Rich