Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate page setup zoom value for 1 to 1 printing
I would like to print three different sheets all at the same zoom level so
that the data columns match from one page to the next. The first page can be printed at 1 to 1, but I cannot retrieve the zoom value from VB that the PageSetup dialog calculates. I would like to set the subsequent sheet print outs to the same zoom magnification. How is the zoom calculated, or how can I get at the zoom value that is automatically calculated when using the GUI? Is there a method I can call? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page Setup Printing | Excel Discussion (Misc queries) | |||
can VBA be used to set page setup for printing? | Excel Discussion (Misc queries) | |||
zoom out for printing in Excel 2002 | Excel Discussion (Misc queries) | |||
Excel Printing and Page Setup | Excel Discussion (Misc queries) | |||
Tips for optimising page setup .Zoom and .FitTo properties | Excel Programming |