Exclude certain cells from printing (they are inside print area)

[alyssa75]

I have hyperlinks in a sheet that go to other sheets in the workbook. They are not relevant when printed so I want them not to print. However, I have them placed within the print area for a clean appearance.

Any way to exclude these cells when printing?

Thanks!

 

[Ruddles]

This is the best I could come up with at short notice: In the ThisWorkbook code module, create an event handler which turns the no-print area to foreground colour white:-

Private Sub Workbook_BeforePrint(Cancel As Boolean)
 
    ThisWorkbook.Sheets("Sheet1").Range("C8:F18").Font.Color = vbWhite
 
End Sub

As there's no Workbook_AfterPrint, we'll have to use some other way of turning the cells black again... maybe the Worksheet_SelectionChange handler:-

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
 
    ThisWorkbook.Sheets("[COLOR=red][B]Sheet1[/B][/COLOR]").Range("[B][COLOR=red]E10:J30[/COLOR][/B]").Font.Color = vbBlack
 
End Sub

When the printing's finished the cells will still be white but as soon as you click back on to the sheet, they'll go black again. Obviously modify the bits in red to suit your purposes and if your background and foreground colours aren't black and white to start with, you'll need to change the colour codes in the VBA.

It's all a bit clunkier than I'd have preferred but if no-one comes up with a better solution, it might do.

(I haven't tested with a real printer but it works with a PDFprinter.)

 

[Anton6908]

Good day Ruddles,
Thanks for this. I get it right to change the text to White.... But the second part to turn it back to Black does not work for me... What could I be doing wrong?

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ThisWorkbook.Sheets("Sheet1").Range("b4:E4").Font.Color = vbWhite
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ThisWorkbook.Sheets("Sheet1").Range("b4:E4").Font.Color = vbBlack
End Sub

 

[Ruddles]

My post was slightly misleading. The Worksheet_SelectionChangeEvent event handler goes in the code module for the sheet you're printing. It gets triggered the next time you click on a cell in that sheet after printing.