Unhide multiple sheets

[albertmb]

Hi everyone,

Can you please help me? Is there a possibilty of unhiding multiple sheets
at the same time?

Thank you
Albert

 

[Eduardo]

Hi,
Try this code I got from the comunity
Sub show_all()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Visible = True
Next
End Sub

Hope this will help if yes please click yes where ask if this post was
helpful. Thank you

 

[Mike]

Only with vba code. Something like this will work
Sub unHideSheets()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Visible = xlSheetVisible
Next
End Sub

 

[albertmb]

Thank you it worked perfectly

Only with vba code. Something like this will work
Sub unHideSheets()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Visible = xlSheetVisible
Next
End Sub