Thread: print preview
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
peter peter is offline
external usenet poster
 
Posts: 29
Default print preview

Hi,
Private Sub cmdpreviewquote_Click()
ufStart.Hide
ActiveWindow.SelectedSheets.PrintPreview
ufStart.Show 'modal
End Sub

The above code works fine. It's just that when I CLOSE the preview, the
background screen never redraws properly. (unless I use "modal")
Any ideas???
peter