Manual Page Breaks in VBA

  • Thread starter Thread starter merlynknight
  • Start date Start date
M

merlynknight

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
 
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.
 
Back
Top