View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] luke.goodsell@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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