ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Code Difference from 2003 to 2007 (https://www.excelbanter.com/excel-programming/435678-code-difference-2003-2007-a.html)

iamnu

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?


All times are GMT +1. The time now is 09:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com