Sub Pro()
Dim i As Integer
Dim Wb As Workbook
Dim sh As Variant
Set Wb = ActiveWorkbook
sh = Wb.Sheets("Parametres").Range("A1:A3").Value
Application.ScreenUpdating = False
'''''''''''''''Wb.Protect ("123")
For i = 1 To UBound(sh) 'Pour chaque lignes du tableau des feuilles'
If sh(i, 1) = "" Or sh(i, 1) = 0 Then GoTo S 'si Vide on se rend à "S"
Sheets(CStr(sh(i, 1))).Protect ("123"), AllowFiltering:=True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True
S:
Next i 'autre'
Application.ScreenUpdating = True
End Sub