Visible Hidden Very Hidden

     

  • Difference between Visible - Hidden - Very Hidden Properties of worksheet Object

    • Private Sub CommandButton1_Click()
    Sheet3.Visible = xlSheetVisible
    End Sub

    Private Sub CommandButton2_Click()
    Sheet4.Visible = xlSheetHidden
    End Sub

    Private Sub CommandButton3_Click()
    Sheet3.Visible = xlSheetVeryHidden
    End Sub

    Private Sub CommandButton4_Click()
    Dim Wkb As Workbook
    Workbooks.Open (ThisWorkbook.Path & "\" & "InputWorkbook.xlsx")
    Set Wkb = ActiveWorkbook
    Wkb.Sheets("Orange").Visible = xlSheetVeryHidden
    Wkb.Sheets("Grapes").Visible = xlSheetHidden
    Wkb.Save
    Wkb.Close
    End Sub

     

    Click On below mentioned image to watch video

    Download The Workbook

     

Hi Everyone,
Welcome to VBA Macros Tutorial. This Tutorial provides comprehensive knowledge on VBA Macros to the user. Hope it enhances your coding skills. If you like this web page kindly Share this to your near and dear. I Prepared this content as per my level of knowledge, if any changes required kindly bring to my notice. Thanks for visiting this web page

Thanks,
Pavan Kumar Gundlapalli