View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default 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