Sub Macro1()
' Touche de raccourci du clavier: Ctrl+h
Dim Sh As Worksheet, Chemin As String
Chemin = ThisWorkbook.Path
For Each Sh In ThisWorkbook.Worksheets
If Sh.Name <> "Total" Then
Sheets(Sh.Name).Copy
ActiveWorkbook.SaveAs Chemin & "\" & Sh.Name & ".xlsx"
ActiveWorkbook.Close
End If
Next
End Sub