Private Sub cmd_Afficher_Click()
[B25,B30,B35,B41,B46,B51,B56,B61,B66,B71,B76,B81] = 0
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
Rows.Hidden = False
For Each Target In [B25,B30,B35,B41,B46,B51,B56,B61,B66,B71,B76,B81]
If Target = 1 Then Target.Resize(5).EntireRow.Hidden = True
Next
End Sub