thnx!

nice idea to use eventproc itself to cancel its own event [suicide]


"Mike H" je napisao u poruci interesnoj
...
Hi,

You might try this:-

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Static Printit As Boolean
If Printit = True Then Exit Sub
Printit = True
ActiveSheet.PrintOut