A client has some sheets in which he sometimes wants to see the detail on the screen yet only print the summary. He has therefore marked the ".Range" rows "Hide when printed."
However, when he expands the sheet, the "Hide when printed" attribute is not carried over to the generated rows.
I pointed out that the simple solution was to click the "Collapse" button before printing, but he feels some of those printing the sheets will not do this resulting in a level of printed detail he does not want distributed.