Code Difference from 2003 to 2007

iamnu

Guest

Posts: n/a

2nd Nov 2009

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?

« Finding Smallest Date in Non Contiguous Range | Conditional Disable ActiveX button on Userform »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Grouping difference between 2003 and 2007	Wes D	Microsoft Excel Misc	0	29th Apr 2010 06:04 PM
difference office 2003 and 2007	hisham	Microsoft Excel Misc	4	26th Mar 2009 02:01 PM
Difference between 2003 and 2007	TBRIGHT5	Microsoft Word New Users	2	9th Aug 2008 10:25 AM
What's difference between 2003 and 2007	MapleE.	Microsoft Powerpoint	2	9th May 2008 01:26 PM
Frame Difference in 2003 and 2007	=?Utf-8?B?U05G?=	Microsoft Word Document Management	2	2nd Jul 2006 03:58 PM