Gridlines have to be chosen each time

J

jknapp1005

It seems to me it used to be that gridlines were the default when printing. I
don't remember always having to choose "sheet" tab and click the "gridlines"
checkbox. I tried to set up XLSTART to have that be chosen automatically, but
it didn't work.

How can I have gridlines on every sheet without having to choose it when
printing?
 
D

Don Guillett

One way would be to put this in the ThisWorkbook module

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.PrintGridlines = 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

Similar Threads

Where are my gridlines 1
Gridlines won't show up in excel 2007 6
Gridlines Hidden by Shading 1
display gridlines with fill color 1
Gridlines not printing?! 7
prevent gridlines from excel 2007 to word 2007 1
my gridlines do not print even tho I have chosen print gridlines 1
Excel 2002 default to printing gridlines 1

Top