Sub toupie()
Rows("7:100").Hidden = True 'masque les lignes 7 à 100
Select Case Range("A1").Value
Case 1
Rows("7:9").Hidden = False
Case 2
Rows("7:12").Hidden = False
Case 3
Rows("7:15").Hidden = False
End Select
End Sub