98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Print Preview Loop
Print Preview Loop
Resolved · Low Priority · Version 2003
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?
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.
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. |
Excel tip:Closing all your workbooks QuicklyHold the SHIFT key down and using the mouse click on the file menu, it will now now CLOSE ALL rather than close. This closes all workbooks down but still leaves the application open. |