Before Print Event or not? 1

[williekay]

I have an excel document that takes a long time to print. The solution is to open the document in page break view, print the document, and return to normal view. I do this usually with a Macro and the Macro works but the Macro placed in the ThisWorkbook section does not???

[ul]
  [li]Private Sub Workbook_BeforePrint(Cancel As Boolean) [/li]
  [li]ActiveWindow.View = xlPageBreakPreview [/li]
[li]ActiveWindow.SelectedSheets.PrintOut Copies:=1,[/li]
[li]Collate:=True   [/li]

 [li] ActiveWindow.View = xlNormalView[/li]

[li]End Sub[/li]

[/ul]

Willie

 

[jges]

You will probably get a better response if you repost your question in forum707.