Sub Masquer_Démasquer()
Dim rng As Range
For Each rng In [G3:AE3]
If rng.Value <> [C5] Then rng.EntireColumn.Hidden = Not rng.EntireColumn.Hidden
Next rng
End Sub
Sub Bouton1_Click()
Masquer_Démasquer
End Sub
Sub Masquer_DemasquerN1()
Dim rng As Range
For Each rng In [G6:AE6]
If rng.Value = "N-1" Then rng.EntireColumn.Hidden = Not rng.EntireColumn.Hidden
Next rng
End Sub
Sub Bouton2_Click()
Masquer_DemasquerN1
End Sub