Two Questions Page Break Preview

[Little Penny]

Is it possible to remove the on screen watermark in the page break
preview?

Also can you lock the page break preview to prevent other uses
changing back to normal view?



Thanks


Little Penny

 

[Corey]

You could use this to change the View B4 the wkb closes:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
If ActiveWindow.View = xlNormalView = True Then ActiveWindow.View =
xlPageBreakPreview
End Sub

Private Sub Workbook_Open()
If ActiveWindow.View = xlNormalView = True Then ActiveWindow.View =
xlPageBreakPreview
End Sub


Corey....