| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clicked NO to save, should have clicked YES | Excel Discussion (Misc queries) | |||
| CommandButton used to hide and unhide rows | Excel Discussion (Misc queries) | |||
| How do I format cells to reveal or hide contents when clicked? | Excel Discussion (Misc queries) | |||
| Hide commandbutton? | Excel Discussion (Misc queries) | |||
| Change cell value when right-clicked/double-clicked | Excel Programming | |||
Threaded Mode
