I am having problems in making a command button invisible (worksheet, not form) after it has been clicked (Excel 2007). I tried this :
Code
Private Sub ShowAsGraph_Click()
'This is what the button should, and does, do.
ActiveSheet.ChartObjects("Dashboard_Chart").Visible = True
'Now I want to hide the button to ensure it does'nt get re-clicked
ActiveSheet.Shapes("ShowAsGraph").Visible = False
'.... but it stays visible.
End Sub
Display More
without effect. I imagine the click-event is refusing to hide its own object because it is still executing.