Record a macro whilst doing this and run it next time you print.

Or use this generic macro which prints just the pre-selected sheets.

Sub Printit()
ActiveWindow.SelectedSheets.PrintOut
End Sub


Gord Dibben MS Excel MVP

On Wed, 21 May 2008 11:59:02 -0700, Luke M
wrote:

Not the best solution, but you can hold down 'ctrl' and select the 4 sheets
you want to print, and then under print options, where you choose what you
want to print, select "active sheet(s)"