View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vacation's Over Vacation's Over is offline
external usenet poster
 
Posts: 279
Default 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!