Welcome to the forum!
Private Sub CommandButton1_Click() Dim c As Range On Error Resume Next For Each c In Range("A1", Cells(Rows.Count, "A").End(xlUp)) Worksheets(c.Value).Visible = xlSheetVisible Next c End Sub
Welcome to the forum!
Private Sub CommandButton1_Click() Dim c As Range On Error Resume Next For Each c In Range("A1", Cells(Rows.Count, "A").End(xlUp)) Worksheets(c.Value).Visible = xlSheetVisible Next c End Sub