VBA to disable gridlines

**Muktar888** · 05-15-2017, 02:04 PM

Hey all

Whats wrong with my code to remove gridlines? :


Sub formatting()

With Worksheets("Lists - Global")
    .DisplayGridlines = False
    
End With


End Sub

**sintek** · 05-15-2017, 02:14 PM

hi muktar888
Try

Sub formatting()
With Sheets("Lists - Global")
    ActiveWindow.DisplayGridlines = False
End With
End Sub

**Muktar888** · 05-15-2017, 02:22 PM

Originally Posted by sintek

hi muktar888
Try

Sub formatting()
With Sheets("Lists - Global")
    ActiveWindow.DisplayGridlines = False
End With
End Sub

Thats it!

Gees how do you guys know when to add these things?

Much appreciated!

**sintek** · 05-15-2017, 02:24 PM

By being taught by others....lol
thanks for rep point and for marking thread as solved....

**Muktar888** · 05-15-2017, 03:05 PM

So i guess its baby steps for me.

Thanks for teaching!

Re: VBA to disable gridlines