Workbook_BeforePrint(Cancel As Boolean) ...how about AfterPr

[bill]

Would like to capture a AFTERPRINT event in EXCEL 97.

Thank you.

 

[Damon Ostrander]

Hi Bill,

There is no AfterPrint event, but you can effectively create your own using the BeforePrint event as follows:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Static PrintRequest As Boolean

If PrintRequest = True Then Exit Sub

PrintRequest = True
ActiveSheet.PrintOut

'PUT YOUR AfterPrint CODE HERE
'This code will execute AFTER the print is completed

PrintRequest = False
Cancel = True
End Sub

The way this works is simply to cancel the manually-requested print, and instead execute a print from VBA so that right after the print you can do whatever operation you want.

Keep Excelling.

Damon

 

[Barrie Davidson]

Damon, what a great idea! I've encountered this before and never even thought of going that route.

Regards,

 

[Ivan F Moala]

Damon

Good idea.....however it's the Printpreview
that usually is the problem for Print event
codes....ie. code will also run in Printpreview........I'm trying to work on
code around this...so far I only have a hack


cheers

Ivan

 

[bill]

Damon,

That was an excellent Idea.

Not too sure about IVAN and the problem he faces using PRINT PREVIEW...

4 now though, the solution is what the doctor ordered!
Bill

 

[Ivan F Moala]

On 2002-03-11 06:43, bill wrote:
Damon,

That was an excellent Idea.

Not too sure about IVAN and the problem he faces using PRINT PREVIEW...

4 now though, the solution is what the doctor ordered!
Bill

Hi Bill...the problem is when you do a printpreview the "AFTER print event" will
still run...try it and see....
This is what I'm trying to work over...
at the moment I just have a Hack fix...

Ivan

 

[bill]

Thanks Ivan,

I actually noticed the flaw when an associate dropped a stack of printouts on my desk due to print preview

No fix yet I presume?