First off VBA is not my strongest skill and I am having issues regarding a form with two main groups of users with different responsibilities for the form.

I have a dropbox with 4 values to mark user changes.
The options are "Edit User", "New User", "Term User" and "Current User".

There is already some timestamp macros and locking macros on the worksheet. The main focus is when a individual attempts to change the dropbox value to "Current User", that it would prompt a password in order to make sure the correct people are verifying the change.

Generally, this code works if hypothetically they double clicked to change, but doesn't offer much safety for a drop down.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If cell.Value = "Current User" Then
Dim pass As String
pass = InputBox("Enter Password")
If pass <> "Coleslaw1" Then
MsgBox ("Wrong password")
Else
Sheets("Step 2 - Supervisor Assignment").Unprotect password:="password"
Target.Locked = False
End If
End If
End Sub


Any ideas or workarounds?