Very Hidden Excel worksheets

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

Leave a Reply

Your e-mail address will not be published. Required fields are marked *