Is there a way to sort worksheets within a workbook

[Mim]

I have a workbook with multiple worksheets. At any given time a macro can be
run to insert and rename a new worksheet. Is there a way to sort selected
worksheets alphabetically within a workbook?

[Dave Peterson]

Chip Pearson's:
http://www.cpearson.com/excel/sortws.htm

David McRitchie's:
http://www.mvps.org/dmcritchie/excel...#sortallsheets

Mim wrote:
>
> I have a workbook with multiple worksheets. At any given time a macro can be
> run to insert and rename a new worksheet. Is there a way to sort selected
> worksheets alphabetically within a workbook?

--

Dave Peterson

[Mim]

Sweet! This worked like a charm!
Thanks,
Mim

"Dave Peterson" wrote:

> Chip Pearson's:
> http://www.cpearson.com/excel/sortws.htm
>
> David McRitchie's:
> http://www.mvps.org/dmcritchie/excel...#sortallsheets
>
> Mim wrote:
> >
> > I have a workbook with multiple worksheets. At any given time a macro can be
> > run to insert and rename a new worksheet. Is there a way to sort selected
> > worksheets alphabetically within a workbook?
>
> --
>
> Dave Peterson
>