Ladies and Germs, lets hear it for SUB Workbook_BeforePrint

[bill]

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]

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

<pre>
Application.Dialogs(xlDialogPrint).Show</pre>

 

[bill]

YES!!!!!!!


thank you!!!!!