Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add print function | Excel Worksheet Functions | |||
function on the print area | Excel Worksheet Functions | |||
Print and Email Function on spreadsheet | Excel Discussion (Misc queries) | |||
Print Worksheets function needed. | Excel Worksheet Functions | |||
function to print to PDF and save PDF file | Excel Programming |