PDA

View Full Version : Solved: Grid lines reappear after running macros



zest1
03-31-2006, 11:47 PM
How does one keep grid lines hidden and retain a white sheet?

I've whited out the grid lines, but then after running my macros (with clear or delete cells routines) the grid lines reappear. Is there a better way than inserting a cell color formatting routine at the end of each macro?



Edit:
I just checked in Tools/Options and oddly, the gridlines checkbox is ticked, when I'm certain I unchecked it. Oh well.

johnske
04-01-2006, 05:12 AM
Perhaps there's some code somewhere putting DisplayGridlines = True? Put in ThisWorkBook code module:Option Explicit

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
ActiveWindow.DisplayGridlines = False
End Sub