Remove Command Button After Click

[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?

 

[Don Guillett]

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

 

[andiam24]

Thanks Don!

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

Glad to help. I never use command buttons. I prefer shapes.

 

[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!