Remove Command Button After Click

A

andiam24

Good Morning,
I would like for the command button, after it has performed the function, to
automatically disappear from the worksheet. Is this possible?
 
D

Don Guillett

Private Sub CommandButton1_Click()
MsgBox "hi"
ActiveSheet.Shapes("CommandButton1").Cut
End Sub
 
A

andiam24

I have just one more problem:
The user worksheet I created has columns that will remain unused if the
checkbox value= false. I would like to have the button (shape) also
hide/delete these columns. Are the checkboxes necessary- I only deemed them
necessary because some of the columns have formulas so I can't just use
value=blank to hide columns.
Thanks in advance for your brain!
 
Top