Remove CommandButton
 

I have added a commandbutton to my worksheet through a
macro. When the button is clicked, I want it to do a
series of things including get rid of the button (whether
it is deleted, hidden, etc.. I don't care I just want it
to not be on the screen any more.)

I am not suceeding at this.

Suggestions?

Thanks

SS

Remove CommandButton
 

SS:
Set the CommandButton's Visible property to False.

Workbook.Worksheets("Sheet1").Shapes("CommandButto n1").Visible = False

Jim

"SS" wrote in message
...
I have added a commandbutton to my worksheet through a
macro. When the button is clicked, I want it to do a
series of things including get rid of the button (whether
it is deleted, hidden, etc.. I don't care I just want it
to not be on the screen any more.)

I am not suceeding at this.

Suggestions?

Thanks

SS