Print all tabs as one print job except 2

[cocoa]

I'd like to print all tabs as one print job (without naming tabs as they may come and go), but exlude the first 2 worksheets (which can be specifically named). Thanks!!

 

[Datsmart]

Take a look at the suggestions here:
http://www.mrexcel.com/forum/showthread.php?t=232643

Similar request.

 

[jim may]

Try,

Sub Foo()
For i = 3 To Worksheets.Count
Worksheets(i).PrintPreview  'change to Worksheets(i).PrintOut once it is working for you in preview mode
Next i
End Sub

 

[cocoa]

Jim - that's wonderful, nice and short, thanks. My utopia would be for it to print as one job (then I get it double-sided), but I will use this unless anyone has a modification to suggest.

Datsmart, thanks very much. Unfortunately, being a total newbie, I don't understand what to change with the "Codename", and when I use the code as is I get only the 1st 2 pages printing, which are the ones I want to exclude.