before print function

[lawson]

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

"lawson" <lawson@discussions.microsoft.com> wrote in message
news:25539FBE-7A90-40AF-95F4-A64B0DDA2E43@microsoft.com...
> 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?
>

[Tom Ogilvy]

There is no after print event.

--
Regards,
Tom Ogilvy

"lawson" <lawson@discussions.microsoft.com> wrote in message
news:25539FBE-7A90-40AF-95F4-A64B0DDA2E43@microsoft.com...
> 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?
>

[Rob Bruce]

lawson wrote:
> 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

--
Rob

http://www.asta51.dsl.pipex.com/webcam/