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!
Advertisement
Code
'============================================
' 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
ws.Activate
' Turn off gridlines
ActiveWindow.DisplayGridlines = False
Next ws
' Go to "A1"
Application.Goto Worksheets(1).Range("A1")
End Sub