Private Sub BtnSAve_Click()
Dim Debut As Integer, Lignes As Integer
On Error GoTo Suite
With ThisWorkbook.VBProject.VBComponents('ThisWorkbook').codemodule
Debut = .ProcStartLine('Workbook_Open', 0)
Lignes = .ProcCountLines('Workbook_Open', 0)
.DeleteLines Debut, Lignes
End With
Suite:
If ActiveWorkbook.Path = '' Then GoTo Original
On Error GoTo Sortir
Application.EnableEvents = False
ChDrive Left(ActiveWorkbook.Path, 1)
ChDir ActiveWorkbook.Path
Original:
Sauvegarde = Application.GetSaveAsFilename('c:\\' _
& ActiveWorkbook.Name, fileFilter:='Classeur Excel (*.xls), *.xls', Title:='Macros EXCEL - Sauvegarder le fichier courant')
If Sauvegarde = False Then Exit Sub
ActiveWorkbook.SaveAs Filename:=Sauvegarde, FileFormat:=xlWorkbookNormal, CreateBackup:=False, AddToMru:=True
Sortir:
Application.StatusBar = False
Application.EnableEvents = True
End Sub