ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide clicked commandButton (https://www.excelbanter.com/excel-programming/378533-hide-clicked-commandbutton.html)

[email protected]

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



All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com