How do I avoid printing cell borders?

[Michael Lanier]

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

 

[Rick Rothstein]

I think this will do what you want (assuming you are using the With
statement you showed in your example)...

..PageSetup.PrintGridlines = False