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