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

[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

 

[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

 

[Kevin]

Ron, Thank you that work.
Kevin Brenner

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

 

[Ron de Bruin]

Hi Kevin

I add a page today to mu site with some examples
Maybe you like it

http://www.rondebruin.nl/tips.htm