Print Preview Freezes

[Charles]

Hi,

Once again I'm stumped.
I created a userform listbox for selection of employees.
After selections I click the "Ok" button
This will do a call to format a worksheet so that it can be printed,
however when I try to run the code by clicking the "Ok" button the
worksheet is formatted but the PrintPreview is frozen and I have to do
a ctrl alt delete to stop the program.
Now i can go to the code that formats the worksheet and run it from
there and the PrintPreview will show, and after it shows I can click
the Print on it.
Prior to the call I unload the userform, but this still fails.
Can anyone shed some light on this?
Thanks

 

[Charles]

Hi,

Once again I'm stumped.
I created a userform listbox for selection of employees.
After selections I click the "Ok" button
This will do a call to format a worksheet so that it can be printed,
however when I try to run the code by clicking the "Ok" button the
worksheet is formatted but the PrintPreview is frozen and I have to do
a ctrl alt delete to stop the program.
Now i can go to the code that formats the worksheet and run it from
there and the PrintPreview will show, and after it shows I can click
the Print on it.
Prior to the call I unload the userform, but this still fails.
Can anyone shed some light on this?
Thanks

Hi,

I found the reason for the freeze.
I had a Screenupdate in the wrong place.
Thanks to all who read this.