displaying gridlines

J

Jerry Hannitan

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.
 
L

little_creature

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top