Tue 17 Mar 2009, 16:48Delegate Derick said...
Derick has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Print Preview Loop
My screen froze when going to Print Preview using a Macro I had previously recorded. How can I prevent this?
Mon 20 Apr 2009, 10:04Trainer Anthony said...
RE: Print Preview Loop
Hi Stephen. There are many possible reasons for this, not least the configuration of your machination - it may simply be hanging because your CPU is struggling to process each procedure. If you've recorded the jump to a print preview using the macro recorder, it might be an idea to code this by hand and strip out any unwanted code such as zoom and page orientation. Also, if you have a dialog box running at the same time, you might need to programmatically close it down, returning focus to the print preview view.
Hope this helps,
Anthony
