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