Hide rows but show when printing

[dyukon]

How can I hide rows in a worksheet but then allows me to see them when I print view or print?

For e.g., hide rows A1 through X5 but I need to see these rows when printing.

[Don Guillett]

Use a before_print macro to be found in the ThisWorkbook module

--
Don Guillett
SalesAid Software
[email protected]
"dyukon" <[email protected]> wrote in
message news:[email protected]...
>
> How can I hide rows in a worksheet but then allows me to see them when I
> print view or print?
>
> For e.g., hide rows A1 through X5 but I need to see these rows when
> printing.
>
>
> --
> dyukon
> ------------------------------------------------------------------------
> dyukon's Profile:
> http://www.excelforum.com/member.php...o&userid=30062
> View this thread: http://www.excelforum.com/showthread...hreadid=501696
>