Unhide Rows when printing

[ElDome]

Greetings All,
Is there a VB routine that can unhide rows when I print?
Thanks

[shg]

Please Login or Register  to view this content.

[royUK]

Try amending this

Please Login or Register  to view this content.

[ElDome]

Thanks for the reply.
I inserted the code in the "This workbook" section of the VB editor however it does not seem to work when I try to print.
Am I missing a step?
Thanks again
Dome

[ElDome]

Thanks again for the reply.
I was successful inserting it; however, it prints one copy before re-hiding and then proceeds to print a second with the rows hidden.
Is there a way to stop the second print?
Thanks

[royUK]

Try this amendment

Please Login or Register  to view this content.

[ElDome]

Hi Thanks for the quick response

Should the "Cancel -True" line be "Cancel=True"
It gives me an error the first way.
When I do change it to the later, it runs, unhides and immediately rehides the row but does not print.

If i change the value to "False" it runs, unhides prints and then hides the rows and reprints the worksheet.

I truly appreciate your help in the matter

[royUK]

Yes, that's a typo, I must have hit the wrong key. Try this

Please Login or Register  to view this content.

[ElDome]

Wow
Thanks again
This time it works except it no longer hides after the print
any clue?

[jindon]

try

Please Login or Register  to view this content.