Code execution interrupted on PrintPreview close

A

AusTexRich

The macro works fine up to the print preview. When I Close from the toolbar
I get the message "Code execution has been interrupted".
What can I add to the macro to prevent the interruption?

Here's the code from the macro

Sub PPreview()

ActiveWindow.FreezePanes = False
ActiveSheet.PageSetup.PrintArea = "PRT_G1"
ActiveWindow.SelectedSheets.PrintPreview
End Sub
 
D

Dave Peterson

It didn't blow up for me (xl2003), but I have seen things like this cause
trouble--but I remember them happening when I'm stepping through the code--not
when I really run it. Am I mis-remembering?

And I don't think that there's anything you can do to stop that--so save your
work often.

Ps. From John Walkenbach's site:
http://j-walk.com/ss/excel/odd/odd11.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print with sevral different print area's 2
Need help modifying code 0
VBA word change keys 0
GetOpenFilename code execution interrupted 5
Word macro that can call cells out of Excel for a find and replace 0
Code Execution was interuppted 0
PrintPreview problem in 2007 1
Loop has goofy message all of a sudden 3

Top