Userform - CommandButton_Click question
 

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

Userform - CommandButton_Click question
 

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


.