don't show the page breaks on the worksheet
 

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?

You can turn off all page breaks under toolsoptionsview 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

"Classic" wrote:

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?

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

Peo Sjoblom wrote:

You can turn off all page breaks under toolsoptionsview 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

"Classic" wrote:

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?

--

Dave Peterson