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
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