View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] merlynknight@msn.com is offline
external usenet poster
 
Posts: 6
Default 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