How to unhide all sheets in Excel at once

In this tutorial you will learn two methods on how to unhide all worksheets in excel at once

1. VBA Code
2. Custom View

VBA Code:
'This code will unhide all sheets in the workbook
Sub UnhideAllWoksheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
End Sub