View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
iamnu iamnu is offline
external usenet poster
 
Posts: 4
Default Code Difference from 2003 to 2007

Excel 2003 Code
Selection.PrintOut Copies:=1, Preview:=True, Collate:=True

In Excel 2003, the above code allows me to Preview a spreadsheet, and
after reviewing it, I can then use the Print button that is at the top
of the preview page, to print it.

When I use this same code in Excel 2007, I can Preview the page, but
everything seems to lock up such that I can't print the preview page.

How is this done?