Is it possible to disallow a sheet in Excel from being hidden? I have a workbook with multiple sheets, many of which can and are hidden if not required. Some of the sheets should always be required, so I want to set the particular sheets to never be hidden.
asked Jun 24, 2016 at 14:28
1 Answer
Protect the workbook with "structure" ticked and set a password.
It is in the "Review" ribbon.
answered Jul 11, 2017 at 5:34
Tim Joy T-Square ConsultingTim Joy T-Square Consulting
3101 gold badge2 silver badges14 bronze badges
Private Sub Workbook_SheetBeforeDelete(ByVal Sh As Object)End Sub