I
iamnu
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?
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?