To restart the page number for every tab of 1st tab 1 of 3 then 2 of 3 then 3 of 3..and same thing for all the other tabs RRS feed

  • Question

  • Can you help me also coz apart from wanting that code I need to print the pages flip over and to make it just black and white also. That code makes everything to be printout without giving me ability to set my printer settings. Pls advice. Thanks in advance!

    Sub printpages() Dim i As Integer

    For i = 1 To ThisWorkbook.sheets.Count ThisWorkbook.sheets(i).PrintOut NextEndSub

    i got this code also from this forum.. thanks

    Tuesday, August 21, 2018 6:44 AM

All replies

  • Hi,

    This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.



    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Wednesday, August 22, 2018 2:06 AM