Is there a way to sort worksheets within a workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
It belongs in a General module--not behind ThisWorkbook and not behind a
Worksheet.

And run it via Tools|Macro|Macros
(xl2003 menu system)
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Sort excel when workbook opened 2
Setting Scope of name ranges to particular worksheet 2
alphabetize worksheet names 4
How to apply macro across multiple worksheets within a workbook 4
Linking multiple worksheets in one workbook 2
moving worksheets 1
Apply different color themes to worksheets withing a workbook 2

Back
Top