Set cells to not print?

**DCSwearingen** · 09-12-2007, 02:36 PM

I am having a brain lapse.

How do I set up to not print certain cells or rows or columns short of hiding them?

**ChemistB** · 09-12-2007, 03:09 PM

You can set a Print area by highlighting the range(s) you wish to have printed and clicking on Print Area -> Set from the File dropdown menu (at least that's how it works in Excel2000). You can highlight non-contiguous areas by holding down the Cntrl key.

ChemistB

**DCSwearingen** · 09-12-2007, 03:18 PM

I thought there was a way to format a cell (or range) to not print, even if it was within the Print Area a different user might select.

Similar to the way text boxes and other graphic items can be set to not print.

Maybe I am mistaken.

**VBA Noob** · 09-12-2007, 03:24 PM

Does this link help

http://www.contextures.com/xlCondFormat03.html#Print

VBA Noob

**DCSwearingen** · 09-12-2007, 03:35 PM

I must have been mistaken about a cell property to not print.

I have used font colors to avoid having something show up in the past.

I have a sheet set up with user instruction scattered around it that I wanted to not be printed.

I may end up having to write some code in the BeforePrint even to specifically exclude my instruction.