Gridlines have to be chosen each time
 

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?

Gridlines have to be chosen each time
 

One way would be to put this in the ThisWorkbook module

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.PrintGridlines = True
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jknapp1005" wrote in message
...
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?