Execute code after printing with the BeforePrint event

From: mikeburg <mikeburg.1w95ib_1128218707.7852@xxxxxxxxxxxxxxxxxxxxx>
Date: Sat, 1 Oct 2005 20:26:23 -0500

Does anyone know of a way to print at a certain place in BeforePrint
Event?

I tried using cancel = True, but it prevents printing from the VBA
code. In other words, the is still some VBA code to execute after
sending documents to the printer.

Thanks for all you help. mikeburg

--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24581
View this thread: http://www.excelforum.com/showthread.php?threadid=472373

.

Follow-Ups:
- Re: Execute code after printing with the BeforePrint event
  - From: Jim Cone

Prev by Date: Retrieve or extract cell formatting information using VBA
Next by Date: Deleting lines with a variable.
Previous by thread: Retrieve or extract cell formatting information using VBA
Next by thread: Re: Execute code after printing with the BeforePrint event
Index(es):
- Date
- Thread

Relevant Pages

Re: Confirm Each Recipient in a New Outlook Mail Before it is Sent
... Does other VBA code run? ... Sue Mosher, Outlook MVP ... (ByVal Item As Object, Cancel As Boolean) ... The e-mail would only be sent after you confirmed the recipients by ...
(microsoft.public.outlook.program_vba)
Re: xlDialogPrint
... The cancel button tells you that the user didn't want to change printers--not ... "Dave Peterson" wrote: ... the xlDialogPrint to appear so they can select an appropriate printer. ... I've already defined those arguments in the VBA code. ...
(microsoft.public.excel.programming)
Re: CHECK FIELD FOR PRINTING
... Please make sure in your reference Library to install the Microsoft DAO Library Support in order for the Database options to work. ... DoCmd.OpenReport "Coupon", acViewNormal 'This is the report that has your coupon designed with the $50.00 on it. ... Conversation: CHECK FIELD FOR PRINTING ... I can give you VBA code examples where that can be done within VBA code without to much programming? ...
(microsoft.public.access.macros)
Re: Prompt for input if another field is not blank
... I tried to test it by putting in an ActualEndDate and it ... >You'll need some VBA code in the BeforeUpdate event of ... >Private Sub Form_BeforeUpdate ... > Cancel = True ...
(microsoft.public.access.forms)
Re: xlDialogPrint
... when the cancel button is press it ... "Dave Peterson" wrote: ... the xlDialogPrint to appear so they can select an appropriate printer. ... I've already defined those arguments in the VBA code. ...
(microsoft.public.excel.programming)