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

Top