Uses the Not operator to effectively toggle the page break display from True to False and from False to True : ActiveWorksheet « Excel « VBA / Excel / Access / Word
- VBA / Excel / Access / Word
- Excel
- ActiveWorksheet
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
Related examples in the same category