How to hide all sheet tabs in a worksheet.

[Yisha]

Hi everyone, how am I going to hide all sheet tabs in my workbook.help needed please.

 

[alansidman]

If you hide all the sheets, nothing will be visible in your workbook. Is this really what you want. Shouldn't you have at least one sheet visible.

 

[jproffer]

Not only should you, but I'm 99% sure you have to leave at least one sheet visible.

 

[Yisha]

Yeah. Thank u for correcting me. What I mean is only the active sheet is visible and the rest were hidden and cannot be unhide easily. Thank u.

 

[Trebor76]

Try this where you can only unhide the tabs through the Visual Basic Editor (VBE) either via more code or by changing each tab's visible property individually:

Option Explicit
Sub Macro1()

    Dim wsMySheet As Worksheet
    
    Application.ScreenUpdating = False
    
    For Each wsMySheet In ThisWorkbook.Worksheets
        If wsMySheet.Name <> ActiveSheet.Name Then
            wsMySheet.Visible = xlSheetVeryHidden
        End If
    Next wsMySheet
    
    Application.ScreenUpdating = True

End Sub

Regards,

Robert