Hide clicked commandButton
Hi!
I would like to hide a button when it has clicked, for example:
Private Sub SomeBtn_Click()
<some code
ActiveSheet.Shapes("SomeBtn").Visible = False
End Sub
but for some reason the button is not being hidden.
The line "ActiveSheet.Shapes("SomeBtn").Visible = False" works fine
when not called by SomeBtn_Click() (or a sub called by
SomeBtn_Click()).
Any ideas?
Many thanks,
Luke
|