Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range, test As Boolean
Set r = [C3:G7] 'plage à adapter
Application.ScreenUpdating = False
r.Hyperlinks.Delete 'RAZ
On Error Resume Next
For Each r In r
If r <> "" Then
test = False
test = r.Validation.Type = xlValidateList
If test Then r.Hyperlinks.Add r, "", "'" & r & "'!A1"
End If
Next
End Sub