Print Area

Hi,

first of all this forum is awesome!!!

I the attatched spread sheet i would like to use a check box to do the following
1. Hide all empty rows
2. set the print area to only rows that contain values (not formulas)
3. Print
4. Unhide all rows
5. reset print area
6. reset the check box