Sub macro_tri()
ActiveWorkbook.Worksheets("Gestion des masques accueil").AutoFilter.Sort. _
SortFields.Clear
ActiveWorkbook.Worksheets("Gestion des masques accueil").AutoFilter.Sort. _
SortFields.Add Key:=Range("B3"), SortOn:=xlSortOnValues, Order:= _
xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Gestion des masques accueil").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub