Unhide All Hidden Worksheets At Once
If you have a workbook with many hidden worksheets, you cannot unhide all of them at once, UNLESS, you use the below VBA Code.. ------------------------------------------------------------------ Option Explicit
Sub UnHideAllSheets() 'Unhides All Worksheets
Dim Sheet As Worksheet
Application.ScreenUpdating = False
For Each Sheet In ActiveWorkbook.Worksheets
Sheet.Visible = xlSheetVisible
Next Sheet
Application.ScreenUpdating = True
En