top of page

Excel Worksheets That Hide Themselves

Most litigation support professionals reviewing produced Excel files, will take the trouble to check for hidden worksheets. Simply, right click on any one 'tab', and select 'Unhide' and click on the worksheets you want to display.

Beware of vba code that automatically re-hides Excel worksheets. Spreadsheets can be set to make a worksheet you unhid disappear again.

See this demonstration. After the worksheet named, 'Data' is unhidden, it disappears again after the user clicks on a different worksheet.

A worksheet can be set to behave this way with the following function:

Private Sub Worksheet_Deactivate()

ThisWorkbook.Sheets("Data").Visible = False

End Sub

. . . but other visual basic code can cause the same behavior.

Don't get tripped up by this setting.

bottom of page