Hiding multiple commandbuttons

[TaskyFuji]

Good morning,

I'd like to ask help to hide multiple commandbuttons. They have different actions and it's a step by step process. So some steps I need to hide multiple command buttons using another commandbutton. I also renamed these commandbuttons (ex. Yes 1, No_1, Backto1). Would deeply appreciate your help. Thanks!

 

[EXCEL MAX]

Hello TaskyFuji,
if your buttons are all on the userform try this...

Private Sub CommandButton1_Click()
    
    Dim vCtrl As Control
    
    With Me
        For Each vCtrl In .Controls
            If Not vCtrl.Name = .ActiveControl.Name And _
                TypeName(vCtrl) = "CommandButton" Then
                vCtrl.Visible = False
            End If
        Next vCtrl
    End With
    
End Sub

 

[Rick Rothstein]

If those CommandButtons are in a "group" without any intervening controls between them, then place a Frame control on the UserForm, put the Command Buttons in the Frame (Cut/Paste them into the Frame), then move the Frame into position, align the CommandButtons as needed and then in the Frame's Property window, delete the Caption, set the BackColor equal to the UserForm's BackColor and change the SpecialEffect property to Flat. After all that is done, one line of code is all you will need then... simply set the Frame's Visible property to False and all the CommandButtons on it will disappear... setting its Visible property back to True will make the CommandButtons all reappear.