• Ask a Question
150
Insert Image Size must be less than < 5MB.
    Ask a Question
    Cancel
    150
    More answer You can create 5 answer(s).
      Ask a Poll
      Cancel
      Top Contributor

      Toggle button

      I’m currently using a toggle button to hide only 1 sheet.  I want to creat another toggle button to hide multiple sheets.  I’ve tried using an Array but it doesn’t seem to work.  I’ll appreciate any help. Thank you.

      Asked by fenway33 on March 21, 2018 in VBA: Macros.
      1 Answers
      Expert

      Sub hide()
      Sheet3.Visible = False
      Sheet4.Visible = False
      Sheet5.Visible = False
      ‘ You can hide as many sheets as you like.
      End Sub
      Sub Unhide()
      Sheet3.Visible = True
      Sheet4.Visible = True
      Sheet5.Visible = True
      End Sub

      Answered by Hyside2 on March 23, 2018..