I don't want to print some cell in my print area

[dumanibo]

There is some value in my table but i don't want to print some cell value in my print area. Also in my page print setup, i selected black and white option.

In this case how can i print my page excluding some cell values?

[Levent Menteşoğlu]

You can make white color of these cells before print

or

You can use like the following code

(copy in thisworkbook code module)

for example: if A1 don't print

copy in normal module


Sub gizle()
[a1].Font.ColorIndex = 2
end sub

Sub goster()
[a1].Font.ColorIndex = 0
end sub
copy in thisworkbook code module

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Call gizle
Application.OnTime Now, "goster"
End Sub

[dumanibo]

Dear leventm,

it doesn't work like that. in my Page Setup, i selected black and white print option. Because there is some colored area i don't want to print.

[Levent Menteşoğlu]

I changed above codes, please try again.