Bonjour à tous,
Il y a du choix ...
Avant la fermeture ...
Private Sub Workbook_BeforeClose(Cancel As Boolean)
WsLock
End Sub
Avant l'enregistrement ...
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
WsLock
End Sub
Après l'enregistrement ...
Private Sub Workbook_AfterSave(ByVal Success As Boolean)
WsLock
End Sub
ric