ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Execute code after printing with the BeforePrint event (https://www.excelbanter.com/excel-programming/341649-execute-code-after-printing-beforeprint-event.html)

mikeburg[_38_]

Execute code after printing with the BeforePrint event
 

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...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=472373


Jim Cone

Execute code after printing with the BeforePrint event
 
mikeburg,

Rob Bruce has a technique here...
http://www33.brinkster.com/rbad/defa...page=newevents

Jim Cone
San Francisco, USA


"mikeburg" wrote in message

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



All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com