how to disable cell printing

R

rozczochrany

I need to do some kind of a form, and i want to block some filled wit
text cells from printing, (i don't want this text witch is in thi
cells to be printed, and i want the others cells to be printed) and
can't find any option to disable cells from printing. Pls hel
.:confused
 
F

Frank Kabel

hi
there's no such option. You have to do this within a macro 8e.g. set
the font color to white)
 
R

Ron de Bruin

If you want to use a macro look here

1) It will make the font white
2) Print
3) Make the font black again

Sub test1()
'Range with one area
With ActiveSheet
.Range("B10:B14").Font.ColorIndex = 2
.PrintOut
.Range("B10:B14").Font.ColorIndex = 1
End With
End Sub

Sub test2()
'Range with more areas
With ActiveSheet
.Range("A1:A3,B10:B14,C12").Font.ColorIndex = 2
.PrintOut
.Range("A1:A3,B10:B14,C12").Font.ColorIndex = 1
End With
End Sub


More info here
http://www.rondebruin.nl/print.htm#Hide
 
Top