ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   print preview (https://www.excelbanter.com/excel-programming/360714-print-preview.html)

peter

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

peter

print preview
 
figured ans
insert
application.screenpdating=true
also...
ufStart.StartUpPosition = 3
recenters form before you call
ufstart.show


thanks
"peter" wrote:

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



All times are GMT +1. The time now is 12:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com