Printing Multiple Sheets in correct order.

J

jarvo

Hi,

I have a Workbook containing 80 worksheets, I would like to create
buttons that when clicked will print a specified selection of th
worksheets.

The issue I have is that worksheets 6,7,8 are printed with eac
selection, but they must be printed in the correct order.
This order is shown below.

(Button 1) Print Worksheets: 1,2,3,4,5,6,7,8,9,10,11,12
(Button 2) Print Worksheets
13,14,15,16,17,18,*6,7,8,*19,20,21,22,23,24,25,26
(Button 3) Print Worksheets: 27,28,29,30,31,32,*6,7,8,*33,34,35,36,37
(Button 4) Print Worksheets
38,39,40,41,42,43,*6,7,8,*44,45,46,47,48,49,50,51,52,53,54
(Button 5) Print Worksheets: 55,56,57,58,59,60,*6,7,8,*61,62,63,64,65
(Button 6) Print Worksheets
66,67,68,69,70,71,*6,7,8,*72,73,74,75,76,77,78,79,80
(Button 7) Prints all worksheets.

When creating a macro it prints the lowest numbered worksheet first.

Thanks for any help
 
R

renegan

This might slow the process a bit but you can select the worksheet firs
(one by one on the order you like) and then give the print command. I
will follow the order you write on your macro then.
You can use Application.ScreenUpdating=False to run it faster
 
J

jarvo

renegan,

thanks for the advice, but i still couldnt get it to work.
Is still prints worksheets 6,7,8 before the others.

any ideas what im doing wrong?

it excel 2003 if that makes any difference.
 
Top