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