VBA Code to Check if Worksheet is Hidden in Excel

This code checks if a specific worksheet is hidden in the workbook.

VBA Code:

Function IsWorksheetHidden(ByVal worksheetName As String) As Boolean
    Dim ws As Worksheet
    
    On Error Resume Next
    Set ws = Worksheets(worksheetName)
    On Error GoTo 0
    
    If Not ws Is Nothing Then
        IsWorksheetHidden = ws.Visible = xlSheetHidden
    Else
        IsWorksheetHidden = False
    End If
End Function

Check All VBA Codes

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group

Leave a Comment