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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page break issues 1
function question?? 12
vba page breaks 3
How to zoom in VBA 4
Counting Manual Page Breaks Only 1
PageSetup.Zoom=TRUE 3
Formating Print Margins 2
recalculate page breaks after setting Zoom in pagesetup 1

Back
Top