Printing pages from different sheets in a set order

[Gordana Godzo]

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: (e-mail address removed)

 

[ADG]

Hi Gordana

I suggest that you use the macro recorder to record the print of the sheets
in the order you require, then and the button and paste in the code. Then
edit the code so that the footer is how you want it. You can also record
this, below is an example of a footer recorded by Excel.

With ActiveSheet.PageSetup
.LeftFooter = "&BClee Hill Electrics Confidential&B"
.CenterFooter = "&D"
.RightFooter = "Page &P "
End With