View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 276
Default 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