don't show the page breaks on the worksheet

[Guest]

After you do a print preview of a worksheet the dotted lines will show your
page breaks on the worksheet. Is there any way to NOT see the dotted lines
after doing a print preview?

 

[Guest]

You can turn off all page breaks under tools>options>view and uncheck page
breaks or use a macro with this line

ActiveSheet.DisplayPageBreaks = False

so you could make 2 macros, one that turns them off and and one that turns
them on. Don't know if it is worth all that work for being a little annoyed

Regards,

Peo Sjoblom

 

[Dave Peterson]

You can turn them on by hitting the print preview button, too.