Excel - Turn Gridlines Off Entire Workbook

This macro turns the gridlines off for the entire workbook.


  • 653
  • 487
  • 1
  • 0
Add to collection
© 2021VBAmacros.net

1 Open MS Excel.

2 Create a blank workbook.

3 Go to Developer's tab > click on "Visual Basic" button or hit Alt + F11.

4 Go to Insert tab > click on "Module" or hit M.

5 Copy the VBA code from below.

6 Paste the code in the newly created module.

7 Go to Run tab > click on "Run Sub/UserForm" or hit F5.

8 That's it!


' Turn Gridlines Off For The Entire Workbook
Sub turnGridlinesOffWorkbook()
    ' Set variables
    Dim ws As Worksheet
    ' Loop thru all worksheets
    For Each ws In Worksheets
        ' Activate worksheet
        ' Turn off gridlines
        ActiveWindow.DisplayGridlines = False
    Next ws
    ' Go to "A1"
    Application.Goto Worksheets(1).Range("A1")
End Sub

Sort by:
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
VBAmacros.net VBAmacros.net
Code was successfully copied!
VBAmacros.net VBAmacros.net
Please sign in!
VBAmacros.net VBAmacros.net
You've already voted!