Evaluating the project

So there you have it. The utility meets all the original project requirements: It sorts all sheets in the active workbook, it can be executed easily, it's always available, it seems to work for any workbook, and I have yet to see it display a VBA error message.

Note The procedure still has one slight problem: The sorting is strict and may not always be "logical." For example, after sorting, Sheet10 is placed before Sheet2. Most would want Sheet2 to be listed before Sheet10.



0 0

Post a comment