bonjour,
voici mon code :
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets("Feuil1").Protect "1234", UserInterfaceOnly:=True, AllowFormattingCells:=True, AllowInsertingRows:=True, AllowDeletingRows:=True, AllowSorting:=True, AllowFiltering:=True, AllowUsingPivotTables:=True
End Sub...