before print function

[Guest]

Private Sub Workbook_BeforePrint(Cancel As Boolean)

End Sub

i want to use this function to take all the color off the print area, but
when its done printing, i want it to return the color. is there anything for
after print?

 

[JulieD]

Hi

would setting file / page setup / sheet tab = black & white = true help

AFAIK this only affects the printing not the viewing of the workbook. You
could leave it set all the time or set it using the before print event, if
you wanted to.

Cheers
JulieD

 

[Tom Ogilvy]

There is no after print event.

 

[Rob Bruce]

Private Sub Workbook_BeforePrint(Cancel As Boolean)

End Sub

i want to use this function to take all the color off the print area,
but when its done printing, i want it to return the color. is there
anything for after print?

<http://www33.brinkster.com/rbad/default.aspx?section=tips&page=newevents>

HTH