Ignore page breaks for hidden rows
 

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

Ignore page breaks for hidden rows
 

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



T Kirtley wrote:

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