Sub recherche_Click(mot)
Dim plage As Range, L As Long, C As Long
ligne = 9
For Each WS In Sheets
If WS.Name <> "Search Item" Then
For L = 1 To WS.Range("A1").SpecialCells(xlCellTypeLastCell).Row
For C = 1 To WS.Range("A1").SpecialCells(xlCellTypeLastCell).Column
If InStr(UCase(WS.Cells(L, C)), UCase(mot)) <> 0 Then
Sheets("Search Item").Cells(ligne, 1).Hyperlinks.Add Anchor:=Sheets("Search Item").Cells(ligne, 1) _
, Address:="", SubAddress:=WS.Name & "!" & Cells(L, C).Address, TextToDisplay:=WS.Cells(L, C).Value
ligne = ligne + 1
trouve = True
End If
Next C
Next L
End If
Next WS
If Not trouve Then MsgBox ("No " & mot & " found in the file")
End Sub