PDA

View Full Version : Printing solution request



av8tordude
07-07-2010, 04:00 PM
I'm using the code below to print a form and sheet, but I would like to preview the sheet before it prints. Unfortunately, the workbook locks up causing me to hard close excel. If I click the cancel button on the print dialog box, frmUserform.PrintForm still prints the userform.

1. Is there a way to preview the sheet without excel locking up
2. If I click cancel on the print dialog box, prevent frmUserform.PrintForm from printing.

Application.Dialogs(xlDialogPrint).Show
frmUserform.PrintForm

Thanks