PrintPreview freezes and does not let me print

[jpgactmod]

I just converted to Excel 2007. The below code in a Visual Basic Module worked fine for Excel 2003, but now it PrintPreviews the worksheets but does not let me actually print or even close PrintPreview. I can scroll through the PrintPreview pages but everything else is frozen. I can only get out of PrintPreview by hitting my "Esc" key.
Any suggestions as to how I can get PrintPreview to actually let me print will be much appreciated.

Sheets(Array("ToC", "Pr_Hdr", "Scenarios")).Select
Sheets("ToC").Activate
ActiveWindow.SelectedSheets.PrintPreview

 

[jake1016]

Hi,

I was wondering if you ever got this to work. I have the same problem.

 

[jpgactmod]

Hi Jake,

I was beginning to think that I was all alone. I am not sure it will solve your problem, but by trial and error I did find what was causing my problem.

I generally turn off "screen updating" in all my macros to speed things up a little and avoid vertigo by watching worksheets bounce all over the place. As you may know, screen updating is turned off as follows:

application.screenupdating = false

This is what caused my problem in Excel 2007 that was not a problem in prior Excel versions. Prior to running the "print preview" command, I turned screen updating on with:

application.screenupdating = true

That solved the problem. Hope it works for you as well - please let me know.

Jim