Public Sub AnnulerFiltreFeuilActive() 'affiche tout et annule filtre
On Error Resume Next
ActiveSheet.ShowAllData
ActiveSheet.AutoFilter.Sort.SortFields.Clear
On Error GoTo 0: Err.Clear
End Sub
Public Sub AnnulerSupprimerFiltreFeuil(F$)
On Error Resume Next
Sheets(F$).ShowAllData 'aff tout
Sheets(F$).AutoFilter.Sort.SortFields.Clear 'annule filtre
Sheets(F$).AutoFilterMode = False 'suppr filtre
On Error GoTo 0: Err.Clear
End Sub