ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hide rows but show when printing (https://www.excelbanter.com/excel-discussion-misc-queries/65387-hide-rows-but-show-when-printing.html)

dyukon

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.


--
dyukon
------------------------------------------------------------------------
dyukon's Profile: http://www.excelforum.com/member.php...o&userid=30062
View this thread: http://www.excelforum.com/showthread...hreadid=501696


Don Guillett

Hide rows but show when printing
 
Use a before_print macro to be found in the ThisWorkbook module

--
Don Guillett
SalesAid Software

"dyukon" wrote in
message ...

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





All times are GMT +1. The time now is 05:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com