Printing pages from different sheets in a set order "Gordana Godzo" <gordanag[ at ]usje.com.mk> 04.06.2006 08:28:56 I don't know if this is possible: I have several sheets in a workbook. In Sheet 1 for example I have three set print areas that should have the numbers 1, 5, 6. The numbers in between are in other sheet. I don't want to enter manually the number on each page. Is there a way to set the order for printing and the page number to come up in the footer? I suppose this will be done with a macro, so I will put a button assigned to the macro, so that everyone who prints it, uses the button and the pages come up in the right order. Any help is appreciated Thanks a lot -- Gordana Godzo Head of Controlling & Budgeting TITAN Group - Cementarnica "USJE" AD Skopje Prvomajska bb, 1000 Skopje Republic of Macedonia tel: +389 2 2786 138 fax: +389 2 2782 535 e-mail: gordanag[ at ]usje.com.mk