With ThisWorkbook
If Not ThisWorkbook.Saved Then
ddate = Application.WorksheetFunction.Max(Sheets("bdd").Columns(9))
dsave = Sheets("formulaire").Range("B1").Value
If ddate - dsave >= 7 Then
Sauvegarde.MSG.Caption = "Attention votre derniere sauvegarde date du " & Sheets("formulaire").Range("b1").Value
Sauvegarde.Show vbModeless
Else
ActiveWorkbook.Save
End If
If Workbooks.Count = 1 Then Application.Quit Else 'ThisWorkbook.Close
End If
End With