before print function
 

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?

before print function
 

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" wrote in message
...
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?

before print function
 

There is no after print event.

--
Regards,
Tom Ogilvy

"lawson" wrote in message
...
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?

before print function
 

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/