VBA – Page Break Preview Mode On or Off

Page Break Preview Mode

To place Sheet1 in Page Break Preview View from code:

Sheet1.Activate

ActiveWindow.View = xlPageBreakPreview

Restore Normal View Mode

To place Sheet1 in in Normal View from code:

Sheet1.Activate

ActiveWindow.View = xlNormalView