Set the Userform's ShowModal property to False.

Cheers,
Dave
-----Original Message-----
When I try to use the command below in a UserForm, I get
locked in
PrintPreview and can't close it or the form. Is there a
way around this?

Private Sub CommandButton1_Click()
Sheets(1).PrintPreview
End Sub


.