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
VBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!