| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "manual page breaks error" | Excel Worksheet Functions | |||
| Dealing with automatic / manual page breaks | Excel Discussion (Misc queries) | |||
| Remove all manual page breaks | Excel Programming | |||
| Count number of manual and automatic vertical page breaks - examples | Excel Programming | |||
| Count the number of just the horizontal manual page breaks | Excel Programming | |||
Threaded Mode
