help for macro

i need macro to do this for me:

i got a button in my worksheet, what i want is when i click it once, the button will be deleted from the worksheet.

how can i do it?

Hi,

Do you really mean delete ... or are you after making your button sometimes visible and sometimes not visible ...?

HTH
Carim

because this button is function for random no, as soon as click once, job done, so it no longer need. so i need it be deleted for ever.

Ok ...

ActiveSheet.Shapes("CommandButton1").Delete

HTH
Carim

How To Use It?

Sub Delete()
ActiveSheet.Shapes("CommandButton1").Delete
End Sub

HTH
Carim