Can you hide and unhide Rows on a worksheet based on their print page number?

[BlindB]

Hi all, long time since the last vist. Glad to see you're still up and running and going strong.

The reason for this visit is I am trying to sort a macro to only show Rows based on print page numbers but am not having any luck at all. I'm not even sure if its possible.

For example, I have a years worth of schedules on one worksheet set out at 52 week intervals using a page break to seperate the weeks for individual printing.

The entire 52 weeks needs to be hidden but a user needs to be able to see two (2) weeks worth of schedules at a time so they can work on them prior to issuing.

Is there any way that a macro can be used that will allow (Unhide) all Rows from the requested print page numbers?


Many thanks and I look forward to any response.