hide page breaks

[ktab]

Hello,

How can i hide the page breaks after print?
I don't mean hide them permanently (tools-options-uncheck page breaks)

Thank you
Kostas

 

[erik.van.geit]

Hello, Kostas,

did you try to record a macro ?

    ActiveSheet.DisplayAutomaticPageBreaks = False

in the workbookmodule

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.DisplayAutomaticPageBreaks = False
End Sub

would this be OK?

kind regards,
Erik

 

[ktab]

Thank you Erik
I have done this already