Sub efface_vba()
Dim VBC As Object
Path = "C:\Users\456910\Desktop"
ActiveWorkbook().SaveAs Filename:=Path & "\Test1.xlsm"
With ActiveWorkbook.VBProject
For Each VBC In .VBComponents
If VBC.Type = 100 Then
With VBC.CodeModule
.DeleteLines 1, .CountOfLines
.CodePane.Window.Close
End With
Else: .VBComponents.Remove VBC
End If
Next VBC
End With
'MsgBox "Modules et macros du classeur actif supprimés.", _
'vbInformation
ActiveWorkbook.Close SaveChanges:=True
End Sub