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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top