sort sheets except the first sheet

[Bill_S]

I've got a workbook where the first sheet contains the user instructions and
the remaining sheets are where the user enters the data. I need a macro to
sort the data sheets numerically but not sort the first sheet, which is named
"Instructions." I looked at the Chip Pearson website but I couldn't figure
out how to exclude my first sheet from the sort.

 

[Pete_UK]

If you named your first sheet "_Instructions" (underscore at the beginning),
then it should sort before numbers and so it will remain in position 1.

Hope this helps.

Pete

 

[Dave Peterson]

Or you could use Chip's macro, but at the end, move the Instructions sheet to
the leftmost position.

'almost all of Chip's code
sheets("Instructions").move _
before:=sheets(1)
End Sub

Why fight it <vbg>.