Skip to content

VBA - Unhide All Worksheets

Source: https://trumpexcel.com/excel-macro-examples/#Unhide-All-Worksheets-at-One-Go

'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

Backlinks:

list from [[VBA - Unhide All Worksheets]] AND -"Changelog"