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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

Thanks Don!

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"andiam24" wrote in message
...
Thanks Don!

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

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!

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"andiam24" wrote in message
...
Thanks Don!

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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