vba row hide

' Classic sheets Worksheets("Sheet1").visible = xlSheetHidden Worksheets("Sheet1").Visible = xlSheetVisible ' Very Hidden sheets Worksheets("Sheet1").Visible = xlSheetVeryHidden Worksheets("Sheet1").Visible = xlSheetVisible

excel vba hide gridlines

Private Sub TurnOffGridLines(target As Worksheet)
    Dim view As WorksheetView
    For Each view In target.Parent.Windows(1).SheetViews
        If view.Sheet.Name = target.Name Then
            view.DisplayGridlines = False
            Exit Sub
        End If
    Next
End Sub

Posted by: Guest on March-18-2021

Source

Code answers related to "vba row hide"

Code answers related to "VBA"

Browse Popular Code Answers by Language

Answers for "vba row hide"

Code answers related to "vba row hide"

Code answers related to "VBA"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us