View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tommy Flynn Tommy Flynn is offline
external usenet poster
 
Posts: 2
Default 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