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

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?

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?

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

There are a few ways:
http://groups.google.com/group/micro...4905543470a0a4



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?

--

Dave Peterson