Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
If Target.Address = "$G$8" Then
Select Case Target.Text
Case Is = "TOUT"
Range("M:W").EntireColumn.Hidden = False
Case Is = "2ème"
Range("M:W").EntireColumn.Hidden = True
Range("N:N,O:O,P:P,Q:Q,R:R,T:T,U:U,V:V").EntireColumn.Hidden = False
Case Is = "3ème"
Range("M:W").EntireColumn.Hidden = True
Range("N:N,O:O,P:P,U:U,V:V").EntireColumn.Hidden = False
Case Is = "4ème"
Range("M:W").EntireColumn.Hidden = True
Range("R:R,T:T,U:U,V:V").EntireColumn.Hidden = False
End Select
Range("A1").Select
End If
Application.ScreenUpdating = True
End Sub