PC Review


Reply
Thread Tools Rate Thread

How to automate Print Zoom to fill page

 
 
Paul Martin
Guest
Posts: n/a
 
      7th Feb 2008
Hi guys

I have written some code that prints combinations of embedded charts.
The code ascertains the TopLeftCell and BottomRightCell ranges in
order to set the print range. When I print, I set the PageSetup to
FitToPagesWide=1 and FitToPagesTall=1. So far, so good. If a print
job is too big, it fits to the page.

What I can't work out, is when the print job is smaller than what
fills a page, I would like to automatically adjust the zoom to fill
the page. I know how to do this to screen, but not with a print job.
Any suggestions?

Thanks in advance

Paul Martin
Melbourne, Australia
 
Reply With Quote
 
 
 
Reply

Thread Tools
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please help! Print Preview Zoom is Grayed Out...Doesn't zoom. PK Microsoft Excel Misc 0 20th Jul 2009 03:33 PM
No zoom in print preview on landscaped page PS Microsoft Excel Misc 4 16th Oct 2008 06:34 PM
How to automate zoom+ in Print Preview KimTong via AccessMonster.com Microsoft Access Reports 2 31st Aug 2007 05:33 PM
Print setup - fit to page - zoom Zurn Microsoft Excel Programming 3 8th May 2006 11:51 AM
Print 2 pages on one page...fill both halves =?Utf-8?B?Si1NYW4=?= Microsoft Excel Misc 2 14th Jan 2004 05:42 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:21 AM.