| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have the checkmark beside print gridlines and they won't print | Excel Worksheet Functions | |||
| not all the gridlines print; despite selecting/"gridlines" | Excel Discussion (Misc queries) | |||
| In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- | New Users to Excel | |||
| How to set DEFAULT print options in Excel to print gridlines? | Excel Discussion (Misc queries) | |||
| My gridlines wont print. Even though i have gone thr print opts? | Excel Discussion (Misc queries) | |||
Linear Mode
