InIT Software Training Blog – On Course for Success

VBA

Remove Page Break Lines in Excel

Remove Page Break Lines in Excel

This video explains how to remove those really annoying page break lines on an Excel worksheet using one line of VBA code. Any level of user can do this.

 VBA Code

Sub PrintLines()
'
'Removes page break dotted lines
'Create in Personal Macro workwook
'PERSONAL.XLSB
'Place link in Quick Access Tool Bar
'
'InITLearning.net
'
ActiveSheet.DisplayPageBreaks = False
End Sub