Gridlines

Changing the appearance of the gridlines is only for worksheets, macro sheets, and dialog sheets since chart sheets have no gridlines.

 

Hide and unhide gridlines

'To hide and unhide gridlines in the active sheet
'in the active window

   'Hide the gridlines
   ActiveWindow.DisplayGridlines = False

   'Unhide the gridlines
   ActiveWindow.DisplayGridlines = True

A workbook can have more than one window by choosing View | Window | New Window. The window of the workbook that you are working on is the active window. Scrolling the active sheet in the active window does not cause scrolling in the other inactive windows. The active sheet can be a worksheet, a chart sheet, a macro sheet, or a dialog sheet.

 

Color 

'To change the gridline color in the active sheet
'in the active window
ActiveWindow.GridlineColorIndex = 3
'3 for red; 4 for green; 5 for blue

 

'To restore gridlines to its default color
ActiveWindow.GridlineColorIndex = xlColorIndexAutomatic