ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Always Print Gridlines (https://www.excelbanter.com/excel-programming/343802-always-print-gridlines.html)

DTTODGG

Always Print Gridlines
 
Hello-
I'm wondering what the best way is to always print gridlines in a worksheet,
no matter who is looking at it.
Also, I tried using a header for a watermark, it looked fine to me. I sent
it out and they couldn't see the watermark. I believe they were using 2003
also.
Thank you!

Vacation's Over

Always Print Gridlines
 
with VBE put this in ThisWorkbook

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


WaterMark Goto:
Aaron Blood
http://www.xl-logic.com/pages/formulas.html
Ron de Bruin
http://www.rondebruin.nl/files/Watermark.zip

"DTTODGG" wrote:

Hello-
I'm wondering what the best way is to always print gridlines in a worksheet,
no matter who is looking at it.
Also, I tried using a header for a watermark, it looked fine to me. I sent
it out and they couldn't see the watermark. I believe they were using 2003
also.
Thank you!



All times are GMT +1. The time now is 11:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com