Bonsoir,
Un exemple pour le principe.
Cdlt.
Public Sub ProtectWorksheets()
Dim wb As Workbook, ws As Worksheet
Set wb = ActiveWorkbook
For Each ws In wb.Worksheets
Select Case ws.Name
Case "Sheet1", "Sheet2", "Sheet3", "Sheet4":
Case Else: ws.Protect
End Select
Next ws
End Sub