displaying gridlines

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerry Hannitan - 25 Sep 2006 05:05 GMT

Does anyone know how to get the gridlines to display on a worksheet?
I went into the preferences menu and the display gridlines box is
checked, the color says automatic, when I change the color to black the
gridlines reappear the way I want them to, however, when I exit out of
Excel the changes aren't saved so the next time I open Excel all I get
is a worksheet without any gridlines.

Reply to this Message

little_creature - 25 Sep 2006 09:51 GMT

Try to add this to your personal.xls
Private Sub displaygrid()
ActiveWindow.DisplayGridlines = True
End Sub

On 25.9.2006 6:05, in article
JEH777-F6DCF3.21051824092006@msnews.microsoft.com, "Jerry Hannitan"
<JEH777@COX.NET> wrote:

> Does anyone know how to get the gridlines to display on a worksheet?
> I went into the preferences menu and the display gridlines box is
> checked, the color says automatic, when I change the color to black the
> gridlines reappear the way I want them to, however, when I exit out of
> Excel the changes aren't saved so the next time I open Excel all I get
> is a worksheet without any gridlines.

Reply to this Message

Mac Forum / Applications / Excel / September 2006

displaying gridlines