Results 1 to 2 of 2
2001-11-05, 20:28 #1
- Join Date
- Sep 2001
- Thanked 0 Times in 0 Posts
Subtotal method, breaks= true, fit to 1 page wide. (xl '97 vba)
With the settings mentioned in the subject line - page breaks do not work. However, if you change the Scaling option "Adjust to: " to what ever the setting was calculated to be - the page breaks WILL work. To solve my problem does anyone know how to calculate that "Adjust to:" property (Zoom)??
I've tried setting the "Fit To" property (FitToPagesWide) with plenty of extra "Pages Tall" (FitToPagesTall) and then tried to read the Zoom property but all I get is "False"..
Any ideas out there?
2001-11-05, 20:48 #2
- Join Date
- Jun 2001
- New York, New York, Lebanon
- Thanked 1 Time in 1 Post
Re: Subtotal method, breaks= true, fit to 1 page wide. (xl '97 vba)
Since you have set the print to be on one page, Excel ignores page breaks. This is the way it works, and you have found out about it.
Now to adjust the zoom, well this is AFAIK a gray area, the Zoom takes two types of arguments.
When you use the FitToPagesWide or FitToPagesTall zoom is False and when you use it, its value is what you set it to be.
There is a way to tell how many page breaks you have, thus the number of pages that would print and then you can set that to match the FitToPagesWide and FitToPagesTall and that would set the zoom.
This method involves the old XLM language and you can find it on the MSKB. Sorry I don't remember the Q number.
Wassim<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>