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
|