Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Dim sa$, feuille$
On Error Resume Next
sa = Target.SubAddress
feuille = Left(sa, InStr(sa, "!") - 1)
With Sheets(feuille)
.Visible = True
.Activate
.Range(sa).Select
End With
End Sub
Petit autre question peut on faire une mise en forme conditionnel sur un lien hypertexte .
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, [E7]) Is Nothing Then Exit Sub
If IsNumeric([E7]) And [E7] > 0 Then [E4].Cut [IV1] _
Else If [IV1] <> "" Then [IV1].Cut [E4]
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, [E7]) Is Nothing Then Exit Sub
With Sheets("TOTO")
If IsNumeric([E7]) And [E7] > 0 Then .[E4].Cut .[IV1] _
Else If .[IV1] <> "" Then .[IV1].Cut .[E4]
End With
End Sub
Private Sub Worksheet_Calculate()
Private Sub Worksheet_Calculate()
With Sheets("Feuil1")
If IsNumeric([C5]) And [C5] > 0 Then .[E4].Cut .[IV1] _
Else If .[IV1] <> "" Then .[IV1].Cut .[E4]
End With
End Sub