Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Fin: If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, [A1]) Is Nothing Then
Application.ScreenUpdating = False
Rows("2:9").EntireRow.Hidden = False
If Target = "Mon entreprise" Then
Range("3:3,5:5,7:7,9:9").EntireRow.Hidden = True
ElseIf Target = "Mes fournisseurs" Then
Range("2:2,4:4,6:6,8:8").EntireRow.Hidden = True
End If
End If
Fin:
End Sub