1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| Sub Option1_Cliquer()
ActiveSheet.Shapes("Option1").Fill.ForeColor.RGB = RGB(90, 155, 230)
ActiveSheet.Shapes("Option2").Fill.ForeColor.RGB = RGB(189, 215, 238)
ActiveSheet.Shapes("Option3").Fill.ForeColor.RGB = RGB(189, 215, 238)
ActiveSheet.Columns("A:K").EntireColumn.Hidden = False
ActiveSheet.Columns("L:AE").EntireColumn.Hidden = True
End Sub
Sub Option2_Cliquer()
ActiveSheet.Shapes("Option1").Fill.ForeColor.RGB = RGB(189, 215, 238)
ActiveSheet.Shapes("Option2").Fill.ForeColor.RGB = RGB(90, 155, 230)
ActiveSheet.Shapes("Option3").Fill.ForeColor.RGB = RGB(189, 215, 238)
ActiveSheet.Columns("B:K").EntireColumn.Hidden = True
ActiveSheet.Columns("L:U").EntireColumn.Hidden = False
ActiveSheet.Columns("V:AE").EntireColumn.Hidden = True
End Sub
Sub Option3_Cliquer()
ActiveSheet.Shapes("Option1").Fill.ForeColor.RGB = RGB(189, 215, 238)
ActiveSheet.Shapes("Option2").Fill.ForeColor.RGB = RGB(189, 215, 238)
ActiveSheet.Shapes("Option3").Fill.ForeColor.RGB = RGB(90, 155, 230)
ActiveSheet.Columns("B:U").EntireColumn.Hidden = True
ActiveSheet.Columns("V:AE").EntireColumn.Hidden = False
End Sub |
Partager