Sub protectPlage()
Dim sh As Worksheet
Dim i As Long
Application.ScreenUpdating = False
For Each sh In ThisWorkbook.Worksheets
With sh
.Activate
.Unprotect "0000"
.Cells.Locked = True
End With
Next sh
For i = 1 To 4
With Worksheets(i)
.Activate
.Range("D3:D45,F3:H45,J3:J45").Locked = False
.Range("D28:D39,F28:H39,J28:J39").Locked = False
.Range("R7:AK23,R30:AK30,R36:AK40").Locked = False
.EnableSelection = xlNoRestrictions
.Protect "0000"
End With
Next i
End Sub