none
Fixed Page Break

    Question

  • Hi Everyone,

    I'm trying to establish a uniform excel 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 excel VBA code for this?

    Thank you very much,

    Zxnjo

    • Moved by litdev Thursday, December 08, 2016 9:01 AM
    • Edited by Zxnjo Thursday, December 08, 2016 10:21 AM
    Thursday, December 08, 2016 7:46 AM

Answers