View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mgill mgill is offline
external usenet poster
 
Posts: 1
Default 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?