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

[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?

 

[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

 

[Dave Peterson]

There are a few ways:
http://groups.google.com/group/microsoft.public.excel.misc/msg/3d4905543470a0a4