Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Printing from Preview Screen

I use the XP version of Excel and have macros that ran fine. Some of the
people I work with have upgraded to Vista and can't print from the Print
Preview menu that is in the VBA code. The line I use is:

Selection.PrintOut Copies:=1, PREVIEW:=True

Afterward, the macro continues to run the remainder of the code.
I am wanting the user to preview the range before printing it and have the
option of printing the document off or canceling it.

I appreciate your help!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
print preview different from screen when using page scaling Shawna Excel Discussion (Misc queries) 0 November 28th 07 10:13 PM
print preview does not look like worksheet screen teflack Excel Worksheet Functions 0 May 26th 06 01:17 AM
Modal Userform and Preview on Screen Jos Vens[_2_] Excel Programming 9 February 13th 06 09:50 PM
Why is the information on preview screen differnt than on normal . kaylaaj Excel Worksheet Functions 1 March 17th 05 06:03 PM
Print Preview Screen in Excel? markverhulst Excel Programming 0 November 17th 04 08:16 PM


All times are GMT +1. The time now is 07:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"