View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How can I make the Standard format for new worksheet have NO grid.

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 Jesson" wrote:

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?