don't show the page breaks on the worksheet

C

Classic

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?
 
P

Peo Sjoblom

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
 
Top