Private Sub Worksheet_SelectionChange(ByVal Target As Range)
mots = Array("bordeaux", "lyon", "paris", "toulouse")
ad = Array("$B$3", "$B$4", "$B$5", "$B$6")
mdp = "ouc"
aff = "******"
For n = LBound(ad) To UBound(ad)
If Target.Address = ad(n) Then
x = InputBox("Mot de passe")
If x = mdp Then Target.Value = mots(n)
End If
If Target <> Range(ad(n)) Then Range(ad(n)) = aff
Next n
End Sub