View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim[_40_] Jim[_40_] is offline
external usenet poster
 
Posts: 5
Default 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