How can I make the Standard format for new worksheet have NO grid.

D

Dave Jesson

I hate gridlines! And I desperately wish to have new worksheets that I insert
into workbooks automaticlly NOT to show gridlines. How can I make Excel do
this?
 
M

Mike H

Only way I know of:-

Alt+F11 double click this workbook and paste it in there.

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

Mike
 
Top