![]() |
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