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