Is there a way to sort worksheets within a workbook

M

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?
 
V

vcff

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
 
D

Dave Peterson

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

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

Dave Peterson

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.
tnks for the reply. Think problem is bcos my is xl2000
Click to expand...
 
Top