Two Questions Page Break Preview
 

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

Two Questions Page Break Preview
 

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....

"Little Penny" wrote in message
...
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