Thread
:
Remove Command Button After Click
View Single Post
#
4
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett