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.

  • Did you try this function Private Sub Workbook_SheetBeforeDelete(ByVal Sh As Object) End Sub
    – Prasanna
    Jun 24, 2016 at 15:30
  • Seems to have no effect Jul 7, 2016 at 15:51

1 Answer 1


Protect the workbook with "structure" ticked and set a password.

It is in the "Review" ribbon.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.