Highlight in Excel but do not print out

T

texansgal

I want to highlight some cells to flag me to fill those in. Is there a way to
show the highlighted part on the screen but NOT when it is printed?

Thanks!
 
M

Marcelo

Hi

file | page setup | Shhet tab - check the B&W box

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"texansgal" escreveu:
 
T

texansgal

I have to have other cells be in Color though.

Marcelo said:
Hi

file | page setup | Shhet tab - check the B&W box

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"texansgal" escreveu:
Click to expand...
 
M

Marcelo

so use a code to eliminate the highlight of these cells, print and highlight
again


***********************************
Sub colored()
Range("YOUR RANGE").Select
Selection.Interior.ColorIndex = xlNone
Range("A1").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Range("YOUR RANGE").Select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
Range("A1").Select
End Sub
********************************************************
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"texansgal" escreveu:
 
Top