Bonjour Mishayou, le forum,
A tester....
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then
Select Case Target.Value
Case Is = "Chef"
ActiveSheet.Shapes("Bouton 1").Visible = False
ActiveSheet.Shapes("Bouton 2").Visible = True
ActiveSheet.Shapes("Bouton 3").Visible = False
Case Is = "Employé"
ActiveSheet.Shapes("Bouton 1").Visible = True
ActiveSheet.Shapes("Bouton 2").Visible = False
ActiveSheet.Shapes("Bouton 3").Visible = False
Case Is = "Direction"
ActiveSheet.Shapes("Bouton 1").Visible = False
ActiveSheet.Shapes("Bouton 2").Visible = False
ActiveSheet.Shapes("Bouton 3").Visible = True
Case Else
ActiveSheet.Shapes("Bouton 1").Visible = True
ActiveSheet.Shapes("Bouton 2").Visible = True
ActiveSheet.Shapes("Bouton 3").Visible = True
End Select
End If
End Sub
Code à placer dans le module de la feuille (alt +F11 pour y accéder).
Cordialement,