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