hide page breaks

ktab

Well-known Member
Joined
Apr 21, 2005
Messages
1,297
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
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hello, Kostas,

did you try to record a macro ?
Code:
    ActiveSheet.DisplayAutomaticPageBreaks = False

in the workbookmodule
Code:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.DisplayAutomaticPageBreaks = False
End Sub

would this be OK?

kind regards,
Erik
 

ktab

Well-known Member
Joined
Apr 21, 2005
Messages
1,297
Thank you Erik
I have done this already ;)
 

Watch MrExcel Video

Forum statistics

Threads
1,111,596
Messages
5,541,150
Members
410,543
Latest member
ExcelGlenn
Top