Sub Protéger()
Dim rrr
Dim ws As Worksheet
rrr = InputBox("donnez le mot de passe svp")
For Each ws In Worksheets
If ws.Name = "Feuil2" Then
ws.Range("a2:a3").Locked = False
ws.Range("a2:a3").FormulaHidden = False
ws.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, Password:=rrr
Else
ws.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, Password:=rrr
End If
Next
End Sub