To stop users from unhiding sheets which they shouldn’t be accessing, hide them using VBA and they can only be unhidden using VBA.
In this example we have a Summary sheet and a Calculations sheet. We don’t want users meddling with the Calculations sheet.
You can right-click the sheet tab at the bottom and select Hide, but this just means someone else can right-click and select Unhide. However, if you run this simple line of VBA:
Sheets(“Calculations”).Visible = xlVeryHidden
Now if you right-click in the sheet tab bar there will be no option to unhide the sheet. The only way to unhide it would be using VBA:
Sheets(“Calculations”).Visible = True