• 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

      Hiding sheets

      I want to have “show sheet tab” unchecked  from the option menu and only be able to unhide the sheets I need to show via macro button.  The only sheet/tab that should be visible when opening the workbook is Setup or home tab but without showing any tabs. I also need all forms of manual “unhide sheet” to be disable.

      Thanks hope this makes sense.

      Asked by fenway33 on June 26, 2017 in VBA: Macros.
      1 Answers
      Expert

      Hi Fenway,

      Here is the code, It doesn’t allow users to un-hide worksheet, you can set the Visible property of worksheet to xlSheetVeryHidden and lock the VBA code. so that user can not un-hide the worksheet. The below example will hide the sheet and user can not see it in Unhide worksheet dialog list.

       

      Sub sbVeryHiddenSheet()
      Sheets("SheetName").Visible = xlSheetVeryHidden
      End Sub
      

       Please find below link to explore more about hide or unhide sheets using VBA macros.

      Hide-Unhide-Worksheets using VBA

      Regards- Valli

      Answered by Valli on August 4, 2017..