Ignore page breaks for hidden rows

[Guest]

Is there a way to ignore page breaks in hidden rows when printing? When I
hide rows that contain page breaks a blank page still prints (except for the
print titles).

I'd rather not use any vba since the security settings of the many users
often block the macros.

Any suggestions?

TK

 

[Dave Peterson]

Maybe you can copy the visible rows to a new worksheet--apply the page breaks
that you need and print from there.