Hide rows but show when printing

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.

Use a before_print macro to be found in the ThisWorkbook module

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"dyukon" <dyukon.21qjzm_1137428701.2489@excelforum-nospam.com> wrote in
message news:dyukon.21qjzm_1137428701.2489@excelforum-nospam.com...
>
> 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
>