Bonjour,
Un double click sur A3 de la feuille 1
Pour adapter à un autre fichier, il faudra adapter les noms de feuilles et adresses.
Un essai ...
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim R As String
Dim Rng As Range
Cancel = True
If Intersect(Target, Range("A3")) Is Nothing Then Exit Sub
R = ActiveSheet.Range("A3").Value
Set Rng = Worksheets("Feuil2").Columns("A:A").Find(what:=R, LookIn:=xlValues, lookat:=xlWhole)
If Rng.Value <> "" Then Worksheets("Feuil2").Range("A" & Rng.Row).EntireRow.Delete
End Sub
ric