![]() |
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 |
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