Crash on Print Preview

**Ttotal** · 03-11-2009, 11:42 AM

Hi,

This file contains the printing options of a larger userform. But I am having problems with the print preview crashing.

I'd click one of the printing options on the userform, this would bring up the print preview of that sheet.

And when I try to "test" its stability by going crazy on the view next/ previous page on preview, it'd crash. This is especially when I've got the screenupdating set to false.

Just wondering if anyone else can varify the crash/ suggest what maybe its cause?

**royUK** · 03-11-2009, 11:44 AM

Do you hide the UserForm before displaying PrintPreview?

**Ttotal** · 03-11-2009, 11:46 AM

No,

Here's an extract of the code:

Please Login or Register  to view this content.

**royUK** · 03-11-2009, 11:48 AM

Try this

Please Login or Register  to view this content.

**Ttotal** · 03-11-2009, 11:48 AM

Sorry, yes I do hide the userform first before print preview. Am I not supposed to?

**royUK** · 03-11-2009, 11:55 AM

I see what's happening. Try this to replace the existing code

Please Login or Register  to view this content.

**Ttotal** · 03-11-2009, 12:10 PM

sorry to report that the problem still exists with your suggested code.

**Ttotal** · 03-11-2009, 01:40 PM

Colpied the entire workbook into a new one - some reason it seems to have solved the problem.

Thanks.

**royUK** · 03-11-2009, 05:10 PM

Originally Posted by Ttotal

sorry to report that the problem still exists with your suggested code.

Yur uploaded workbook worked perfectly after I changed the code as above.

**Ttotal** · 03-12-2009, 05:22 AM

Originally Posted by royUK

Yur uploaded workbook worked perfectly after I changed the code as above.

Yep, it works well now. Since then I coded the "close active worksheet" into the SortPrint sub to save a few extra lines.

Also changed the "application.goto" to .select to simplify the code. But thats the difference between two oranges really.

Again, thanks for the suggestions.