Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Uses the Not operator to effectively toggle the page break display from True to False and from False to True

Sub TogglePageBreaks()     On Error Resume Next     ActiveSheet.DisplayPageBreaks = Not ActiveSheet.DisplayPageBreaks End Sub