Hide command button once clicked

lacombeg · Mar 9, 2011

Hello,

I have a command button in one of my spreadsheet and once I clicked on it, I would like it to be hidden, how do I do that?

Thanks

rs2k · Mar 9, 2011

This will hide the button (Button from the control toolbar NOT the forms toolbar)

Code:

Private Sub CommandButton1_Click()
CommandButton1.Visible = False
End Sub

HTH
Colin

Michael M · Mar 9, 2011

Also, remember to put

Code:

CommandButton1.Visible = true

in either your close workbook event or your open event otherwise it will stay hidden.

lacombeg · Mar 14, 2011

Thank you very much for your help.