Hide/Unhide sheets

[Duncan Butterworth]

To hide multiple sheets in a workbook you can highlight the tabs you want hidden and hide them all.
My question is how do you unhide multiple tabs without having to do each one seperately.
Thanking you in advance.

Regards,
Duncan

 

[GlennUK]

You can't do it in one operation.

 

[ogo]

Is it like this what u meant,

Sub hideSheets()
       For Each Sheet In Sheets
            If Sheet.Name = "Sheet1" or Sheet.Name = "Sheet2"  Then
                Sheet.Visible = xlSheetVisible 
           End If
       Next

End Sub

Thanks,
Ogo