Excel: Sort Worksheets Ascending or Descending
Written by Hii Hiong Ching on October 31, 2008 – 8:21 pm -This is VB code which will auto sort all sheets in the active workbook after execute it. It is easy for us to locate sheets when we have many sheets in our workbook.
Write the Code
Open the workbook for which we want to sort the sheets and press Alt + F11 to open the Visual Basic Editor, and select Insert > Module to insert a module. Copy and paste the following code in module just created.
Popularity: 9%
| Posted in »