Yes

Do it manually by dragging the sheet tabs into the order you want.

It is not difficult to copy the code from Chip's site to a module in your
workbook as I have explained.

You can't break anything by trying on a copy of your original workbook.

Put in a little effort and you will soon learn to deal with VBA.


Gord

On Wed, 21 Jun 2006 12:59:56 -0500, Bro23
wrote:


is there any different way to do it beside that^^^

Gord Dibben MS Excel MVP