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
|