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
|