Manual Page Breaks in VBA
 

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

Manual Page Breaks in VBA
 

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.

" wrote:

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