Discussion:
Manual Page Breaks in VBA
(too old to reply)
m***@msn.com
2008-09-14 22:36:09 UTC
Permalink
I just ran into something that I don't understand.
I have a sheet that code sets to zoom=70.
I then remove previous page breaks using .ResetAllPageBreaks
I put the new page breaks in using .HPageBreaks.Add.
The breaks are there now but zoom is reset to 100%.
If I remove the .ResetAllPageBreaks from the code then everything
works fine and the zoom stays set.
Why would .ResetAllPageBreaks reset zoom?
Merlyn
JLGWhiz
2008-09-15 00:26:01 UTC
Permalink
It is probably because the default page size is based on so many line with
the default 10 point courier font. But I am just guessing.
Post by m***@msn.com
I just ran into something that I don't understand.
I have a sheet that code sets to zoom=70.
I then remove previous page breaks using .ResetAllPageBreaks
I put the new page breaks in using .HPageBreaks.Add.
The breaks are there now but zoom is reset to 100%.
If I remove the .ResetAllPageBreaks from the code then everything
works fine and the zoom stays set.
Why would .ResetAllPageBreaks reset zoom?
Merlyn
Loading...