ExcelBanter - Gridlines: I want them to print default, not have to select it ev.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Gridlines: I want them to print default, not have to select it ev. (https://www.excelbanter.com/excel-discussion-misc-queries/9785-gridlines-i-want-them-print-default-not-have-select-ev.html)

jack ritterskamp

Gridlines: I want them to print default, not have to select it ev.

I "always" want gridlines when I print out a spreadsheet. I know how to turn
them on using the Setup/Sheet checkbox. What I'm after is a way to make them
"on" by default, and turn them off the one time in a hundred when I don't
want them.

Don Guillett

Set up your workbook.xlt or a workbook_open event to select all sheets and
edit the setup

--
Don Guillett
SalesAid Software

"jack ritterskamp" <jack wrote in
message ...
I "always" want gridlines when I print out a spreadsheet. I know how to
turn
them on using the Setup/Sheet checkbox. What I'm after is a way to make
them
"on" by default, and turn them off the one time in a hundred when I don't
want them.

All times are GMT +1. The time now is 01:15 PM.