Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ActiveSheet.PageSetup.Zoom | Excel Programming | |||
pagesetup.zoom problem !!! | Excel Programming | |||
Need Code to Set Scaling Zoom in PageSetup in Auto_Open Sub | Excel Programming | |||
read ZOOM after setting FitToPagesWide in pagesetup | Excel Programming | |||
read ZOOM after setting FitToPagesWide in pagesetup | Excel Programming |