Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Preview Freezes
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Preview Freezes
On Jun 29, 3:18*pm, Charles wrote:
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plot Area Automatically Expands in Print and Print Preview | Charts and Charting in Excel | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
print preview v page break preview | Excel Discussion (Misc queries) | |||
Print Preview Freezes Excel 2003 (spoolsv.exe) | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) |