Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another way to suppress print besides Cancel = True?
I have the following code to execute BeforePrint event. Private Sub Workbook_BeforePrint(Cancel As Boolean) If ActiveSheet.Name = "Print Envelopes" Then Application.OnTime Now + TimeValue("00:00:05"), ThisWorkbook.Name & "!PrintEnvelopes" Cancel = True End If End Sub The problem is that I have a print routine within the code to be executed 5 seconds after clicking & the Cancel = True prevents it. Is there another way to suppress printing without using Cancel = True in the BeforePrint event? I want to be able to print via clicking printer Icon or running the code. Thanks a million. mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=490604 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I suppress the text in Excel an just print the cells I want t | Excel Discussion (Misc queries) | |||
BeforeDoubleClick Cancel=True not working | Excel Programming | |||
Before print, cancel print and cancel copy/paste | Excel Programming | |||
Setting Cancel = True in WorkbookBeforePrint | Excel Programming | |||
cancel a print | Excel Programming |