How do I avoid printing cell borders?

  • Thread starter Thread starter Michael Lanier
  • Start date Start date
M

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
 
I think this will do what you want (assuming you are using the With
statement you showed in your example)...

..PageSetup.PrintGridlines = False
 
Back
Top