Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
print function in excel
i have a template made and working mostly fine but i need two things and
unfortunately i do not know codes and stuff. on the first three tabs (sheet1, sheet2, sheet3), i do not want them to print - at all; on the last tab, (sheet4). i only want that to print if two conditions are met. the first, is a date value and i had help getting that set up but i no longer have contact information of the person on this group that helped fix that problem for me. the date value works fine. the second condition on sheet4 that must be true before it prints is cell D7 must be 0 before it prints. i tried to just add a line to the date macro but i do not think it is as easy as i had hoped. if any one can help, thank you, jatman |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
print function in excel
Post the code you have that is working. Probably a BeforePrint macro.
-- Regards, Tom Ogilvy "jatman" wrote in message ... i have a template made and working mostly fine but i need two things and unfortunately i do not know codes and stuff. on the first three tabs (sheet1, sheet2, sheet3), i do not want them to print - at all; on the last tab, (sheet4). i only want that to print if two conditions are met. the first, is a date value and i had help getting that set up but i no longer have contact information of the person on this group that helped fix that problem for me. the date value works fine. the second condition on sheet4 that must be true before it prints is cell D7 must be 0 before it prints. i tried to just add a line to the date macro but i do not think it is as easy as i had hoped. if any one can help, thank you, jatman |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
print function in excel
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "DSR" Then Cancel = True Application.EnableEvents = False With ActiveSheet If .Range("D1") < "[Ctrl] ;" Then .PrintOut End If End With Application.EnableEvents = True End If End Sub jat "Tom Ogilvy" wrote: Post the code you have that is working. Probably a BeforePrint macro. -- Regards, Tom Ogilvy "jatman" wrote in message ... i have a template made and working mostly fine but i need two things and unfortunately i do not know codes and stuff. on the first three tabs (sheet1, sheet2, sheet3), i do not want them to print - at all; on the last tab, (sheet4). i only want that to print if two conditions are met. the first, is a date value and i had help getting that set up but i no longer have contact information of the person on this group that helped fix that problem for me. the date value works fine. the second condition on sheet4 that must be true before it prints is cell D7 must be 0 before it prints. i tried to just add a line to the date macro but i do not think it is as easy as i had hoped. if any one can help, thank you, jatman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2008 for Mac - Why no Print Preview function? | Excel Discussion (Misc queries) | |||
Hide Print function from excel file | Excel Discussion (Misc queries) | |||
First page of Excel sheerepeats in print layout or print preview | Excel Discussion (Misc queries) | |||
How to enable Excel print function ? | Setting up and Configuration of Excel | |||
Call Excel Print Function, But Not Through a Macro | Excel Programming |