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

  • Thread starter Thread starter Kevin
  • Start date Start date
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
 
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, 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...
 
Back
Top