LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 41
Default PageSetup.Zoom=TRUE

I have a worksheet with e.g. 25 pages. I want to set the Zoom value that e.g.
4 of the original pages fit to one new page via VBA.
For this I select 4 original pages, define this range as PrintArea and set
the Pagesetup to Fit to 1 page wide by 1 page tall with FitToPagesWide and
FitToPagesTall. Before I have to set .Zoom to FALSE.
With this setting the Zoom value is set to e.g. 34%. Then I want to set
Zoom=True and select the whole sheet as PrintArea.
Question: How can I read out the Zoom value als long as Zoom=False, or how
can I set Zoom=True without setting a specific Zoom value?
Thanks in advance for all helps.

Regards
reklamo

 
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
ActiveSheet.PageSetup.Zoom No Name Excel Programming 1 December 13th 05 10:24 PM
pagesetup.zoom problem !!! Olivier[_3_] Excel Programming 3 October 22nd 04 04:34 PM
Need Code to Set Scaling Zoom in PageSetup in Auto_Open Sub Phil Hageman[_3_] Excel Programming 3 April 20th 04 09:11 PM
read ZOOM after setting FitToPagesWide in pagesetup Dave Peterson[_3_] Excel Programming 1 September 3rd 03 11:45 AM
read ZOOM after setting FitToPagesWide in pagesetup richard daniels Excel Programming 1 September 2nd 03 02:07 PM


All times are GMT +1. The time now is 07:13 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"