Is there a way to sort worksheets within a workbook
 

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?

Is there a way to sort worksheets within a workbook
 

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

Is there a way to sort worksheets within a workbook
 

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

Is there a way to sort worksheets within a workbook
 

Hi Dave

I follow your link to copy the SortWorksheetsByName code into the worksheet,
this workbook or module but it didn't work. Where should I copy the code to?

r
vcff

"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

Is there a way to sort worksheets within a workbook
 

It belongs in a General module--not behind ThisWorkbook and not behind a
Worksheet.

And run it via Tools|Macro|Macros
(xl2003 menu system)

vcff wrote:

Hi Dave

I follow your link to copy the SortWorksheetsByName code into the worksheet,
this workbook or module but it didn't work. Where should I copy the code to?

r
vcff

"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


--

Dave Peterson

Is there a way to sort worksheets within a workbook
 

tnks for the reply. Think problem is bcos my is xl2000

"Dave Peterson" wrote:

It belongs in a General module--not behind ThisWorkbook and not behind a
Worksheet.

And run it via Tools|Macro|Macros
(xl2003 menu system)

vcff wrote:

Hi Dave

I follow your link to copy the SortWorksheetsByName code into the worksheet,
this workbook or module but it didn't work. Where should I copy the code to?

r
vcff

"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


--

Dave Peterson

Is there a way to sort worksheets within a workbook
 

I don't think that's the problem. That code will work fine in xl2k.

Maybe it's time to describe what you did and what the problem is--and what you
wanted.

vcff wrote:

tnks for the reply. Think problem is bcos my is xl2000

"Dave Peterson" wrote:

It belongs in a General module--not behind ThisWorkbook and not behind a
Worksheet.

And run it via Tools|Macro|Macros
(xl2003 menu system)

vcff wrote:

Hi Dave

I follow your link to copy the SortWorksheetsByName code into the worksheet,
this workbook or module but it didn't work. Where should I copy the code to?

r
vcff

"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


--

Dave Peterson


--

Dave Peterson