print preview loop

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Print Preview Loop

Print Preview Loop

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Closing all your workbooks Quickly

Hold 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.

View all Excel hints and tips


Server loaded in 0.09 secs.