Make a command button self-distruct

[Jack Brown]

Excuse my ignorance, but how can I make a command button self destruct?
I'm making an excel 'zerg rush' style game thingy.
:yes
Thanks

[mdmackillop]

Like this?

Private Sub CommandButton1_Click()
MsgBox "About to self destruct"
Me.Shapes("CommandButton1").Delete
End Sub

[Jack Brown]

Perfect! Thanks!

[Jack Brown]

This is probably quite an unusual question, but how could I make a command button self destruct if another command button lands on it? I cannot record this as I do not know which command button will land on what command button...
Thanks:rofl:

[mikerickson]

Buttons don't land.

What are you trying to do.

[GTO]

Buttons don't land.

:outtahereBut if they never land, how do they get on the sheet?

(Sorry Mike, I just couldn't resist)

[Jan Karel Pieterse]

Please be aware that removing or adding an ActiveX control on a worksheet resets the code in the file in question.

[mikerickson]

Rather than destroying controls, it is probably better to make them not visible.

[Jack Brown]

Ok. I was trying to make a 'zerg rush' game where little squares (command buttons) jump round and when one lands on your square your square 'dies'.