Salut le forum
Une autre facon
Private Sub Worksheet_Activate()
ActiveSheet.Protect Password:="12345", UserInterfaceOnly:=True
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Locked = True
End Sub
Mytå
P.S. le ActiveSheet.Protect Password:="12345", UserInterfaceOnly:=True
peut-être mis sur une boucle qui scan les feuilles concernées dans Workbook_open
Private Sub Workbook_Open()
With [Feuil1]
.Protect Password:="12345", UserInterfaceOnly:=True
.Cells.Locked = False
End With
End Sub