Manual Page Breaks in VBA

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
 
J

JLGWhiz

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

Counting Manual Page Breaks Only 1
vba page breaks 3
Formating Print Margins 2
Page Breaks in Excel 8
Excel Delete Multiple Page Breaks w/in Selected Rows 6
How to zoom in VBA 4
Page break issues 1
Page Breaks in VBA Q 6

Top