Bonjour ben63,, le forum,
Re Ergotamine
Une alternative avec un ToggleButton (bouton à bascule)....
Private Sub ToggleButton1_Click()
With ToggleButton1
.Caption = IIf(ToggleButton1 = True, "Masquer feuille Canon", "Afficher feuille Canon")
.BackColor = IIf(ToggleButton1 = True, vbRed, vbGreen)
With Sheets("Canon"): .Visible = IIf(ToggleButton1 = True, True, False): End With
End With
End Sub
Cordialement,