Remove CommandButton

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

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
 
SS:
Set the CommandButton's Visible property to False.

Workbook.Worksheets("Sheet1").Shapes("CommandButton1").Visible = False

Jim
 
Back
Top