Excel restricted access

[balajivenkateshan]

Hi Guys,

I would like to restrict access to different users in excel when they select the list in the drop down selection.

I have 2 tabs a 'PL tab' for different departments and the 'data dump' tab from where its getting the data for the selected dept in 'PL tab' drop down list.

there are more than 30+ dept and I don't want people view details of other dept

is it even possible

[EINSTEIN_007]

The sheet in which you can try to hide and unhide with a password, then just right click with the mouse on the tab name and then copy the below code and then hide it, after that when trying to open the sheet from the menu, it will ask for the password, change the 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

[balajivenkateshan]

hi,

Thanks for the reply, but here I have just two tabs and the details keep changing depending on what you select in the drop down, I have attached a simple template, with the Marks of pple not I the 1st sheet there you can see the marks depending on what name you select.

Now I want a restriction , where in one cannot see other candidates marks except for the himself.

Did you get it...