Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Print Preview Loop
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Print Preview Loop
Resolved · Low Priority · Version 2003
Reply 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?
For upcoming training course dates see: Pricing & availability
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
Mon 27 Apr 2009: Automatically marked as resolved.
|