"ActiveWindow.SelectedSheets.PrintPreview" 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

 

[SkipVought]

Hi,

This is an MS Access forum; not Excel.

Please repost in Forum707.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[jpgactmod]

Thank you. Sorry for my confusion.