Multiple issues regarding print, formatting, and form generating

Hello,

With your help in the past, i've created the excel file in the attachment:
it looks up values, using "coordinates" in different sheets of the excel

What i can't do, or i don't know how is:

1. I want to make a print button, on the "calculatie" sheet, for the range a4:d34, but i want it to print only if it has values in columns b or c (or only one of them), because i don't want to print a full empty list with only 2 or 3 or "n" rows.

The print button is kind of done, , but i don't know how to remove rows that have no data in them.

the macro used is:

PHP Code: 

Sub MyPrint()
 curPrtArea = ActiveSheet.PageSetup.PrintArea
  myPrtArea = "E3:G20"
   ActiveSheet.PageSetup.PrintArea = myPrtArea
   ActiveSheet.PrintOut
 ActiveSheet.PageSetup.PrintArea = curPrtArea
End Sub 


2. For economic reasons, i would like that when i press the button, the filled color in cells should not be printed, so i would print only in black and white. Is there any command that i can insert in the macro so the color filling is not printed?

There's more, but i haven't got to that part yet