Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 363
Default .PrintPreview ONLY Page 1

ActiveWindow.SelectedSheets.PrintPreview

Is there a way i can ONLY View Page 1 with the code above ?


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,624
Default .PrintPreview ONLY Page 1

One way:

ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Preview:=True


In article ,
"Corey" wrote:

ActiveWindow.SelectedSheets.PrintPreview

Is there a way i can ONLY View Page 1 with the code above ?

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
PrintPreview Gerry Verschuuren Excel Discussion (Misc queries) 5 October 23rd 07 06:24 PM
userform and printpreview Pierre via OfficeKB.com[_2_] Excel Programming 2 November 16th 05 07:30 AM
printpreview Alex Excel Programming 5 September 12th 05 10:26 PM
PrintPreview Zoom CG Rosén Excel Programming 3 August 19th 05 04:45 AM
PrintPreview doesn't work Roy Barr Excel Programming 2 March 28th 05 01:22 PM


All times are GMT +1. The time now is 03:36 PM.

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

About Us

"It's about Microsoft Excel"