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

--
Rick (MVP - Excel)


"Michael Lanier" <(E-Mail Removed)> wrote in message
news:3d29d1d8-eb7d-47f6-ae16-(E-Mail Removed)...
>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