Often when I'm working with a workbook, we have multiple (sometimes dozens) of different sheets in a file. It can be frustrating to unhide all those tabs manually to see the data. Below is a simple snippet that will quickly unhide all tabs in the workbook.
'Run this code to unhide all tabs in workbook
On Error Resume Next
t = ActiveWorkbook.Sheets.Count
For i = 1 To t
ActiveWorkbook.Sheets(i).Visible = True
It's worth mentioning the three types of Visible statuses available to us:
Hopefully this saves you some time - I know it will for my projects.