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

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