Ladies and Germs, lets hear it for SUB Workbook_BeforePrint

bill · Apr 19th, 2002, 10:49 AM

Hello,

I'm using the Workbook_BeforePrint subroutine to manually print jobs as I must make adjustments to FOOTERS and the like.

I ran into a snafu (above and beyond the PRINT PREVIEW issue in which the code kicks off even though you did not wish to print).

Without the procedure in place, one can (from the Workseet Menu Bar) select FILE>PRINT and be prompted with a print dialog window.

From there you can select a variety of print options.

Unfortunately, the procedure in question WILL NOT prompt for print options from FILE>PRINT. This might cause the user to print gobs of stuff (if my sneaky VBA has its way).

So, is there a way to call the window from VBA?

Thanks most kindly

[ This Message was edited by: bill on 2002-04-19 10:49 ]

[ This Message was edited by: bill on 2002-04-19 10:50 ]

[ This Message was edited by: bill on 2002-04-19 10:51 ]

Mark O'Brien · Apr 19th, 2002, 11:09 AM

Not quite sure what you're asking for here. Is it this you want?



Application.Dialogs(xlDialogPrint).Show

bill · Apr 19th, 2002, 01:15 PM

YES!!!!!!!

thank you!!!!!

Apr 19th, 2002, 11:09 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,521	Not quite sure what you're asking for here. Is it this you want? Application.Dialogs(xlDialogPrint).Show __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 10:49 AM	#1
bill Board Regular Join Date: Mar 2002 Location: Houston TX Posts: 550	Hello, I'm using the Workbook_BeforePrint subroutine to manually print jobs as I must make adjustments to FOOTERS and the like. I ran into a snafu (above and beyond the PRINT PREVIEW issue in which the code kicks off even though you did not wish to print). Without the procedure in place, one can (from the Workseet Menu Bar) select FILE>PRINT and be prompted with a print dialog window. From there you can select a variety of print options. Unfortunately, the procedure in question WILL NOT prompt for print options from FILE>PRINT. This might cause the user to print gobs of stuff (if my sneaky VBA has its way). So, is there a way to call the window from VBA? Thanks most kindly [ This Message was edited by: bill on 2002-04-19 10:49 ] [ This Message was edited by: bill on 2002-04-19 10:50 ] [ This Message was edited by: bill on 2002-04-19 10:51 ]

Apr 19th, 2002, 01:15 PM	#3
bill Board Regular Join Date: Mar 2002 Location: Houston TX Posts: 550	YES!!!!!!! thank you!!!!!