Private Sub Workbook_Open()
Dim plage
With Feuil1 ' A adapter
If .FilterMode Then .ShowAllData
If .[a4] = "" Then .[a4] = "Date"
Set plage = .Range("$A$4:$A$" & .Cells(.Rows.Count, "A").End(xlUp).Row)
End With
plage.AutoFilter Field:=1, Criteria1:="<" & CDbl(Date)
On Error Resume Next 'rien a filtrer
plage.Offset(1).Resize(plage.Rows.Count - 1).EntireRow.SpecialCells(xlCellTypeVisible).Delete
plage.AutoFilter
End Sub