Unhide all Excel worksheets at once
How to unhide all of the Excel worksheets at once using VBA
Sub Unhide_All_Worksheets()
'declare a variable
Dim ws As Worksheet
Dim ws As Worksheet
'unhide all worksheets in this workbook
For Each ws In ThisWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
For Each ws In ThisWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
End Sub
OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
EXPLANATION
This tutorial explains and provides step by step instructions on how to unhide all worksheets at once using VBA.
This tutorial explains and provides step by step instructions on how to unhide all worksheets at once using VBA.
VBA Method: Using VBA you can unhide all worksheets at once with a For Loop that will go through each worksheet in the workbook and unhide all of the hidden worksheets.