You could install a BeforePrint macro into the workbook that goes through the sheet and hides unused rows, prints, then unhides the rows again... Is VBA ok?

Otherwise you will be manually unprotecting and hiding rows.

If VBA is ok, post your workbook and point out the sections of rows where you want this evaluation to occur. Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.