Fixed Page Break

[nhinx]

Dear Excel Experts,

I'm trying to establish a uniform document so that which ever computer or printer they use, the output is still the same. I want the page break of first page be in row 61 while succeeding pages will be in every 56 rows. Also, when someone removed or reset the page break it should go back to the settings that I want. For example if the page break is already in row 61 and I added some rows, it should go back to row 61 and every 56 rows of succeeding pages when I switch to other sheets. Kindly help me generate a VBA code for this?

Thank you very much,

Nhinx

 

[CalcSux78]

You can reset and reprogram page breaks via VBA with this:

    'reset pagebreaks
ActiveSheet.ResetAllPageBreaks
    'add new page break (new page starting at what range)
ActiveSheet.HPageBreaks.Add Range("A62")

 

[nhinx]

Hi CalcSux,

Thank you for your code. However, after running the code I have now 2 Page Breaks. The one is the solid blue line which was assigned by the code in row 62 and the other one is the automatic Page break which is the blue broken line in row 60.

Nhinx

 

[CalcSux78]

If your Page Break exceeds the available space on the current page, excel will automatically insert a "soft break." If you're requiring the first break to be at line 62, you'll need to look into adjusting margins or row heights.

 

[nhinx]

Yeah right, but it needs to be fixed since my template format should be same if I will disseminate it to my colleagues.

Thanks,

Nhinx