How not to print a cell in the middle of a print area

K

Kevin

I have a time sheet with some information like the "Now" date and the name
of the day in another cell. These cells are in the middle of the printing
area and what I want is for these 2 cell not to print, but I want then to be
visible in the screen so I can read them. If I make them white I can't see
them in the screen. Can I just make a textbox and write a formula like
"=C3", where C3 is the "Now" date and set the property of the textbox not to
print.

Thanks in advance!

Kevin Brenner
 
R

Ron de Bruin

Try this Kevin

The macro will make the font white
Print the sheet
Make the font black after that

Sub test()
Range("a1,b14").Font.ColorIndex = 2
ActiveSheet.PrintOut
Range("a1,b14").Font.ColorIndex = 1
End Sub

Post back if you need something else
 
K

Kevin

Ron, Thank you that work.
Kevin Brenner

Ron de Bruin said:
Try this Kevin

The macro will make the font white
Print the sheet
Make the font black after that

Sub test()
Range("a1,b14").Font.ColorIndex = 2
ActiveSheet.PrintOut
Range("a1,b14").Font.ColorIndex = 1
End Sub

Post back if you need something else
Click to expand...
 
Top