Printing Multiple Sheets in correct order.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jarvo - 30 Mar 2006 16:21 GMT

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

Reply to this Message

renegan - 30 Mar 2006 16:37 GMT

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

Reply to this Message

jarvo - 03 Apr 2006 09:57 GMT

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.

Signature

jarvo

Reply to this Message