Hello all,

I am using the following code in to call a print preview from a
userform

Private Sub JobPrint()

Me.Hide
ThisWorkbook.Sheets("PSheet").PrintPreview
Me.Show

End Sub

When I click on the print button on my userform a sub "builds" a
worksheet that contains all the information I want to print. The sub
then hides the userform and calls a print preview of the worksheet.

When I close the print preview (by clicking the Close button) and
Excel shows the userform again, it doesn't return to the print sub
from which it was called, so the print sub which called the print
preview does'nt complete its execution.

Any ideas or help would be great.

Thanks in advance.

DarrenW