Option Explicit
Private BeforeClosing As Boolean
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If ThisWorkbook.FullName = "chemin cible" Then Cancel = Not BeforeClosing
BeforeClosing = False
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
BeforeClosing = True
Application.Dialogs(xlDialogSaveAs).Show
End Sub