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.

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

My Power Utility Pak add-in includes a much more sophisticated sheet sorting utility that handles the potential problem described in the preceding Note.

Chapter 10

0 0

Post a comment