Password for drop down list

Hi

I able to create data validation drop down list etc. I want to assign passwords to different text strings (users) in the list. I have tried searching and found this thread on HERE. Its perfect for myself and confident i can update it as necessary.

I was hoping to make it more user friendly for other colleagues. I was hoping my validation list could be in separate file with usernames in row A and their passwords in row B. My intention would be the file with validation list would be password protected for only the boss to update.

Thanks in advance.

Thanks for reply. I'm able to do the list. But:

Const Mike As String = "Mike1"
Const Alan As String = "Alan1"
Const Bob As String = "Bob1"
Const Pete As String = "Pete1"

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
Dim pwd As String
Dim Oops As Boolean

Application.EnableEvents = False

For Each cell In Target
    If Not Intersect(cell, Range("B7")) Is Nothing And cell <> "" Then
        pwd = Application.InputBox("Password for " & cell & ":", _
                    "Enter Password", Type:=2)
        Select Case cell.Value
            Case "Mike"
                If pwd <> Mike Then Oops = True
            Case "Bob"
                If pwd <> Bob Then Oops = True
            Case "Alan"
                If pwd <> Alan Then Oops = True
            Case "Pete"
                If pwd <> Pete Then Oops = True
        End Select
        
        If Oops Then
            MsgBox "Bad password"
            cell = ""
        End If
    End If
Next cell

Application.EnableEvents = True
End Sub

Is there a way of not having to manually input names and passwords into this code. Instead it will look at column A and B in the other file (where my validation list will be).

Thanks

Hi Leith Ross. Please excuse me if I just being dum. Its the password for each name in the validation list I want to achieve. Without having to manually put the passwords in the code above. There is a link to an example file in original post.

In code above, to select mike from the list you have to input Mike1 as password first. So instead of these lines

Const Mike As String = "Mike1". It will look at A1 for name B1 for password, A2 & B2 etc etc. My validation list code be from A1:A30 and corresponding passwords for those names would be in B1:B30

Thanks for reply. Very new to excel. Shall read up on how to achieve the above