[RESOLVED] Excel - how do you hide a button

[doasidont]

How can I hide and then unhide a button on a worksheet? Thanks.

[sevenhalo]

Like this?

Private Sub CommandButton1_Click()
    CommandButton1.Visible = False
End Sub
 
Private Sub Worksheet_Activate()
CommandButton1.Visible = True
End Sub

[DKenny]

Hopefully this give you the general idea.

You will need to change "CommandButton1" to the name of your button and will need to change the worksheet number to whichever sheet has the button.

Sub ToggleButton()
    With Worksheets(1).Shapes("CommandButton1")
        If .Visible = False Then
            .Visible = True
        Else
            .Visible = False
        End If
    End With
End Sub

[doasidont]

Terrific. Thanks.