Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I avoid printing cell borders?
I have several sheets that have cells (sometimes in a range) with
borders. I do not want the borders to print. I presume I would use something similar to the following: Private Sub Workbook_BeforePrint(Cancel As Boolean) With Worksheets("Sheet1") . . . . Any suggestions would be appreciated. Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I avoid printing cell borders?
I think this will do what you want (assuming you are using the With
statement you showed in your example)... ..PageSetup.PrintGridlines = False -- Rick (MVP - Excel) "Michael Lanier" wrote in message ... I have several sheets that have cells (sometimes in a range) with borders. I do not want the borders to print. I presume I would use something similar to the following: Private Sub Workbook_BeforePrint(Cancel As Boolean) With Worksheets("Sheet1") . . . . Any suggestions would be appreciated. Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell borders are displayed but not printing or on print preview | Excel Discussion (Misc queries) | |||
I am having trouble printing basic cell borders in Excel 2007. | Excel Discussion (Misc queries) | |||
Printing with cell borders | Excel Discussion (Misc queries) | |||
Non Printing of Cell borders | Excel Discussion (Misc queries) | |||
Cell borders printing black instead of grey | Excel Discussion (Misc queries) |