Hi Excel Gods and Goddesses! i am back.. I am still new to the forum, so please forgive me if i have broken any rules. If you point them out to me, i will be sure to not make the same mistake!

So i need some expert assistance -

i have a vba code that prompts the user of my spreadsheet for a password when selecting from a drop down list (data validation).
I need a secondary cell to remain blank - i.e. not calculate/execute the formula until AFTER the correct password has been entered.

Any guidance is super super appreciated!!! code is below 

Option Explicit
Const customer As String = "YPZrC4bm"

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("B6:C6")) Is Nothing And cell <> "Select" Then
        pwd = Application.InputBox("Password for " & cell & ":", _
                "Enter Password", Type:=2)
        Select Case cell.Value
            Case "sepcific customer "
                If pwd <> customer Then Oops = True
End Select
        
        If Oops Then
            MsgBox "Bad Password"
            cell = "Select"
        End If
    End If
  Next
  
Application.EnableEvents = True

End Sub