Handling multiple sheet simultaneously is too much challenging and complex task for anybody. Considering this point, Excel is powered with hide and unhide functionality which helps end user to make visible required sheets for data manipulation. But, excel has a limitation to unhide multiple sheets at a single go. Thus, it becomes a very tedious and time consuming task to unhide multiple sheets in single attempt.
Can we unhide all hidden excel sheets at single attempt?and the answers is "Yes".
Here is the code which will make this task very simple.
Dim i As Integer For i = 1 To ThisWorkbook.Sheets.Count ' You can insert your customized if condition here to unhide specific excel sheet If Sheets(i).Visible = False Then Sheets(i).Visible = xlSheetVisible End If Next i End Sub
Please refer Downloads to get Hide/Unhide add_ins.