View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Remove Command Button After Click

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?