Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
'Private Sub Worksheet_Change(ByVal Target As Range)
Dim I As Byte, J As Byte, Tab1, Tab2
J = 255
Dim Lien As String
Tab1 = Array(14, 16, 18, 20)
Tab2 = Array("Votre Buanderie", "Votre Cuisine", "Hébergement", "Adoucisseur")
If Not Intersect(Target, Range("E:E")) Is Nothing Then
Application.EnableEvents = False
For I = 0 To UBound(Tab1)
If Tab1(I) = Target.Row Then J = I
Next I
If J = 255 Then Exit Sub
If Target(1) = "" Then
If Sheets(Tab2(J)).Visible Then Sheets(Tab2(J)).Visible = False
Else
If Not Sheets(Tab2(J)).Visible Then Sheets(Tab2(J)).Visible = True
With Sheets("Page de garde")
Lien = "'[" & ThisWorkbook.Name & "]" & Tab2(J) & "'!B2"
temp = Target(1)
.Hyperlinks.Add Anchor:=.Range("E" & Target.Row), Address:="", _
SubAddress:=Lien, TextToDisplay:=temp
End With
End If
Application.EnableEvents = True
End If
End Sub
Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink)
Dim NomFeuille As String
If Flag = True Then Exit Sub 'ajout bidouille
NomFeuille = Split(Split(Target.SubAddress, "'")(1), "]")(1)
If NomFeuille = "Buanderie" Then Exit Sub 'ajout bidouille
Sheets(NomFeuille).Visible = True
Sheets(NomFeuille).Select
Range("B2").Select
End Sub